QlikSense Data Architect: Questions With In-Depth
Solutions
Slowly Changing Dimensions Right Ans - Data that changes slowly but
unpredictably
Solution: Interval match function
Line Chart Right Ans - Display trends of a given measure or measures over
time.
KPI Right Ans - Display one or two aggregated measure values.
Text & image Right Ans - Display text, images, links, and measures.
Distribution Plot Right Ans - Compare the overall range and distribution of
individual values in a measure field.
Gauge Right Ans - Display an indicator representing the position of a
measure along a range.
Histogram Right Ans - Evaluate the shape of a distribution curve, generated
by the grouping of values in a measure field.
Table Right Ans - Display numbers and text string values organized into
columns and rows.
Bar Chart Right Ans - Compare aggregated measures by the length or
height of bars.
Pie Chart Right Ans - Display percentage contributions toward a total.
Scatter Plot Right Ans - Discover correlations, clusters, or outliers based on
two measures.
Box Plot Right Ans - Compare distributions in the form of box-and-whisker
diagrams, and discover outliers.
Map Right Ans - Display point, line, and area data upon geographic maps.
, Filter Pane Right Ans - Make selections to reduce data set and view green,
white and gray associative color-coding.
Waterfall Chart Right Ans - Display the cumulative effect of positive and
negative contributions on an initial starting amount.
Treemap Right Ans - Display data, organized into a hierarchy of categorical
groupings, where relative rectangle size relates the magnitude of a measure,
or nested measure values.
Combo Chart Right Ans - Compare measures which occupy different data
ranges, using bars, lines, or markers.
Pivot Table Right Ans - Create a cross table view of data with the potential
to rearrange dimensions and measures.
Steps to Build App Right Ans - Load data, Review data model, develop
sheets, analyze sheets, build a story, play story
3 Main Components of a Qlik Sense App Right Ans - Sheets, Stories, Data
3 Places you can Create Master Items Right Ans - Master items section in
Assets panel, Data model views Preview panel, and Fields section in Assets
panel
Smart Search (What is searched?) Right Ans - Values across all fields,
where matches are determined by hits from the beginning of a substring
within the value
Assets Panel (What is searched?) Right Ans - Chart type names, custom
object names, field names, master item names and master item tags
Dimension and measure selection dialogs (What is searched?) Right Ans -
Field names and names of master dimensions or measures
Filter panes, Tables, and selection item dialogs (What is searched?) Right
Ans - Values in a specific field, where matches are determined by hits at the
beginning of a substring within the value
Solutions
Slowly Changing Dimensions Right Ans - Data that changes slowly but
unpredictably
Solution: Interval match function
Line Chart Right Ans - Display trends of a given measure or measures over
time.
KPI Right Ans - Display one or two aggregated measure values.
Text & image Right Ans - Display text, images, links, and measures.
Distribution Plot Right Ans - Compare the overall range and distribution of
individual values in a measure field.
Gauge Right Ans - Display an indicator representing the position of a
measure along a range.
Histogram Right Ans - Evaluate the shape of a distribution curve, generated
by the grouping of values in a measure field.
Table Right Ans - Display numbers and text string values organized into
columns and rows.
Bar Chart Right Ans - Compare aggregated measures by the length or
height of bars.
Pie Chart Right Ans - Display percentage contributions toward a total.
Scatter Plot Right Ans - Discover correlations, clusters, or outliers based on
two measures.
Box Plot Right Ans - Compare distributions in the form of box-and-whisker
diagrams, and discover outliers.
Map Right Ans - Display point, line, and area data upon geographic maps.
, Filter Pane Right Ans - Make selections to reduce data set and view green,
white and gray associative color-coding.
Waterfall Chart Right Ans - Display the cumulative effect of positive and
negative contributions on an initial starting amount.
Treemap Right Ans - Display data, organized into a hierarchy of categorical
groupings, where relative rectangle size relates the magnitude of a measure,
or nested measure values.
Combo Chart Right Ans - Compare measures which occupy different data
ranges, using bars, lines, or markers.
Pivot Table Right Ans - Create a cross table view of data with the potential
to rearrange dimensions and measures.
Steps to Build App Right Ans - Load data, Review data model, develop
sheets, analyze sheets, build a story, play story
3 Main Components of a Qlik Sense App Right Ans - Sheets, Stories, Data
3 Places you can Create Master Items Right Ans - Master items section in
Assets panel, Data model views Preview panel, and Fields section in Assets
panel
Smart Search (What is searched?) Right Ans - Values across all fields,
where matches are determined by hits from the beginning of a substring
within the value
Assets Panel (What is searched?) Right Ans - Chart type names, custom
object names, field names, master item names and master item tags
Dimension and measure selection dialogs (What is searched?) Right Ans -
Field names and names of master dimensions or measures
Filter panes, Tables, and selection item dialogs (What is searched?) Right
Ans - Values in a specific field, where matches are determined by hits at the
beginning of a substring within the value
