Skip to main content Skip to complementary content

Preserved properties

QV2QS maps QlikView object properties to Qlik Sense equivalents during conversion. This reference documents every preserved property per object type, including conditional mappings and properties that require manual review.

For the object type mapping overview, see Object type mapping.

For cross-cutting features that apply to multiple object types (expressions, number formatting, sorting, visual cues, reference lines, trendlines, font handling, and dimension groups), see Object conversion details.

Common properties

The following properties are preserved for all converted objects regardless of type.

Property Conversion behavior
Title Mapped from the QlikView caption text or title text. If both a title and a caption are defined, the title maps to the Qlik Sense title and the caption maps to the subtitle.
Subtitle Mapped from the QlikView caption text when a separate title is also present.
Footnote Mapped from the QlikView help text.
Show condition Preserved by wrapping the object in a single-child layout container with a condition entry. Qlik Sense does not support show conditions directly on visualization objects.
Calculation condition Preserved on chart and table types. The condition expression and the custom error message are both applied to the hypercube definition.
Alternate state Objects bound to an alternate state retain the same state binding. State names are applied to the object, the hypercube, and the list object (for filter panes).
Background color Solid background colors are preserved, including alpha transparency. For sn-text objects, background color expressions are also preserved. For other types, only constant colors are converted.
Title font styling Font family, size, bold, italic, and underline are converted. Colors are checked against the background for WCAG contrast (minimum ratio 2.0) and replaced with a legible default if the contrast is insufficient.

Charts

Properties common to all charts

The following properties are preserved for all chart visualizations. Per-chart-type properties are listed in the subsequent sections.

Property Conversion behavior
Dimensions Expression, label, sort criteria, null suppression, show condition, and library ID (for master dimensions) are preserved.
Measures Expression, label, number format, sort criteria, show condition, and accumulation modifier are preserved. When a QlikView measure has accumulation enabled, QV2QS generates a Qlik Sense accumulation modifier with the rewritten expression, step count, and base expression.
Persistent colors When enabled in QlikView, the first dimension is configured for byDimension color mode with persistent=true and useDimColVal=true in Qlik Sense. A color attribute dimension is added to the first dimension if not already present.
Color by expression Measure-level colorByExpression attributes are detected. When present, the chart color mode is set to byExpression with expressionIsColor=true.
Sort by Y value When the QlikView chart sorts dimensions by Y value, the first dimension sort criteria is set to sort by expression using the first measure.
Reference lines Label, value expression, color, line style (solid, dashed, dotted), line thickness, and show condition are preserved. Combo charts support reference lines on the primary Y, secondary Y, and X axes. Scatter plots use separate X and Y reference line arrays.
Trendlines Type (linear, polynomial degree 2-4, exponential, logarithmic, power, average) and dash style are preserved.
Visual cues QlikView threshold-based color cues are converted to nested If() color expressions using RGB() or ARGB() functions. Both text color and background color cues are converted.
Cyclic group measures Measures belonging to QlikView cyclic groups are split into a primary measure and alternative measures. The alternative measures are stored in the visualization properties so that users can cycle between them.
Overflow handling When a chart exceeds Qlik Sense dimension or measure limits, excess items are moved to alternatives and the object is flagged for manual review.
Trellis mode Charts with trellis enabled are split into a master visualization (chart minus the trellis dimension) and a qlik-trellis-container that references the master. The trellis dimension (dimension 0) becomes the faceting field in the container data definition. Grid columns and rows are preserved.
Accumulation Measures with accumulation enabled receive a Qlik Sense accumulation modifier. The expression is rewritten using RangeSum() and Above() with set analysis bounds adapted to the dimension field type. Full and step accumulation modes are both supported. Two-dimension charts use an additional expression wrapper to nest the accumulation within the outer dimension context.

Bar chart

Property Conversion behavior
Stacking Grouped or stacked bar grouping is preserved. Stacked charts with two or more dimensions use stacked data mode so that all dimensions contribute to the stacking.
Orientation Horizontal and vertical orientations are preserved. The reverse_orientation flag inverts the default axis direction.
Numeric X-axis When enabled, the chart uses continuous axis mode (preferContinuousAxis=true).
Waterfall detection Bar charts with offset expressions are automatically converted to waterfall charts. The conversion is flagged for manual review.

Line chart

Property Conversion behavior
Line style Solid, dashed, and dotted line styles are preserved.
Line curve mode LINEMODE_STRAIGHT maps to linear and LINEMODE_SMOOTH maps to monotone.
Show symbols The data point visibility flag is preserved.
Area mode QlikView area charts (LINECHART_AREA, LINECHART_3DAREA) are converted to Qlik Sense area line charts (lineType=area). Multi-series area charts are converted with stacked area enabled.
Orientation Horizontal line charts set the Qlik Sense orientation to vertical (axis swap).
Numeric X-axis When enabled, the chart uses continuous axis mode.
Legend Show flag and docked position (top, bottom, left, right) are preserved.

Combo chart

Property Conversion behavior
Series type per measure Each measure retains the assigned series type: bar, line, or marker. The default is bar for the first measure and line for subsequent measures.
Axis assignment per measure Each measure retains the assigned primary or secondary Y-axis binding. The default is the primary axis for the first measure and the secondary axis for subsequent measures.
Symbol mode QlikView symbol modes (circle, square, diamond, triangle) are mapped to Qlik Sense marker types. Filled and outline variants are preserved where Qlik Sense supports the variant. Plus, cross, and line modes map to the line marker.
Stacking Bar grouping mode (grouped or stacked) is preserved.
Orientation Horizontal and vertical orientations are preserved.
Dual Y-axis Per-measure axis assignment (primary or secondary) is preserved. Both axes receive Qlik Sense default settings for show, dock, and auto min/max.
Stock detection Combo charts with stock/candlestick expressions (high, low, open, close) are automatically converted to boxplots.

Pie chart

Property Conversion behavior
Persistent colors Dimension-based persistent coloring is applied.

Pie charts receive default Qlik Sense label and legend settings. QlikView pie chart configuration options beyond persistent colors map to Qlik Sense defaults without additional customization.

Scatter plot

Property Conversion behavior
Trendlines Measure-level trendlines are synced to the chart-level trendline list with scatter-specific axis and dimension settings applied. Trendlines are deduplicated by ID.
Persistent colors Dimension-based persistent coloring is applied.

Treemap

Property Conversion behavior
Persistent colors Dimension-based persistent coloring is applied.
Labels Header, overlay, and leaf labels are enabled by default. Value labels are disabled.

Treemap charts use stacked data mode with full expansion enabled and zero suppression enabled.

Grid chart

Property Conversion behavior
Color by expression If a measure has a color expression, the expression is applied as a color-by-expression attribute. If no measure has a color expression, a color-by-measure attribute is added to the second dimension using the first measure expression as the coloring basis.
Dimension limit QlikView grid charts with more than two dimensions are truncated to two. Excess dimensions are moved to alternatives.

Radar chart

Property Conversion behavior
Color schema A fixed 12-color palette is applied. QlikView radar chart colors do not map directly to the Qlik Sense radar chart extension color model.
Dimension padding The Qlik Sense radar chart extension requires exactly 2 dimensions. When a QlikView radar chart has only 1 dimension, QV2QS inserts a synthetic first dimension. The constant expression ='<FieldName>' uses the original dimension field as FieldName. The original dimension becomes the second dimension (spokes).
Dimension grouping When two or more dimensions are present, the second dimension receives an OTHER_COUNTED specification with a limit of 20 values.

The QlikView radar chart type is converted to the Qlik Sense viz bundle extension qlik-radar-chart.

Gauge

Property Conversion behavior
Gauge type QlikView circular and speedometer modes map to radial gauges. Straight, test tube, reflected tube, traffic light, and digit modes map to bar gauges.
Orientation Bar gauge orientation is derived from the QlikView horizontal flag and gauge mode. Vertical bar modes (test tube, reflected tube, traffic light) default to vertical. Straight and digit modes default to horizontal.
Min and max bounds Gauge axis minimum and maximum values are preserved. Both numeric literals and expressions are supported.
Segments Multi-segment gauges preserve segment boundary values and colors. When QlikView stores boundaries as ratios (0 to 1), QV2QS converts the ratios to absolute values using the gauge min and max. Expression-based boundaries are preserved as value expressions.

When a gauge has zero or one segment, the color is applied as a single progress color. When a gauge has multiple segments, individual segment colors and boundary limits are configured.

Waterfall chart

Property Conversion behavior
Value types Measures with bar offset expressions are assigned the INVERSE value type. Measures without offsets receive the NORMAL value type.
Subtotals The last QlikView measure is removed from the measure list and the measure label is applied as the subtotal label on the preceding measure. Subtotals are enabled on the penultimate measure.
Segment colors Positive, negative, and subtotal segment colors use fixed defaults. QlikView waterfall color customization is not preserved.

Funnel chart

Property Conversion behavior
Persistent colors Dimension-based persistent coloring is applied.
Funnel mode The Qlik Sense funnel mode is set to width-based.

The QlikView funnel chart type is converted to the Qlik Sense viz bundle extension qlik-funnel-chart-ext. Borders are removed from the converted object.

Mekko chart

Property Conversion behavior
Persistent colors When enabled, persistent coloring is applied through the cell-level color property rather than the standard chart color property. The coloring mode is set to byDimension with a colorByAlternative attribute dimension added to the first dimension using the dimension field expression.

Boxplot

Boxplot objects are created from QlikView combo charts that contain stock/candlestick expressions. The conversion maps stock expression components to boxplot elements.

Property Conversion behavior
OHLC expressions High maps to the last whisker. Low maps to the first whisker. The lesser of open and close maps to box start, and the greater maps to box end, so the box renders correctly for both bullish and bearish candles. The box middle is calculated as the midpoint of open and close.
Candlestick coloring The QlikView color expression is preserved. When no color expression is defined, a default expression is generated: red when close is less than open (bearish), green otherwise (bullish).
Dimension sort The sort criteria from the last QlikView dimension is applied to both the inner and outer hypercube dimensions.

When only high and low expressions are present (no open or close), the whiskers and box edges overlap (first whisker and box start both use low, last whisker and box end both use high) and the box middle is the midpoint of high and low.

Tables

Straight table (sn-table)

Property Conversion behavior
Column order Preserved from the QlikView DisplayPosition attribute on each dimension and measure.
Sort order The inter-field sort order is preserved. Per-column sort criteria (numeric, alphabetic, load order, expression) are converted.
Totals Total row position (top, bottom, or hidden) and custom total label are preserved. Expression-based total labels are supported.
Aggregation function The QlikView total aggregation mode (sum, min, max, average, count, expression) is mapped to the Qlik Sense qAggrFunc property per measure.
Null symbol Custom null symbols are preserved. The special value - (hyphen-minus) is converted to an empty string with a null cell background color applied.
Text wrapping Cell and header text wrapping settings are preserved.
Suppress header The header visibility flag is preserved.
Column-level color expressions Per-dimension and per-measure background color expressions and text color expressions are preserved as attribute expressions on each column.
Mini-charts QlikView mini-chart columns are converted to Qlik Sense inline visualizations. The chart type (sparkline, bars, dots, positive/negative), dimension, colors (main, min, max, start, end), Y-axis scale (global or local), and zero baseline are preserved.
Cell styling See the table styling section below.
Horizontal tables QlikView transposed (horizontal) tables are flagged for manual review. Qlik Sense does not have a native horizontal table mode.

Pivot table (sn-pivot-table)

Property Conversion behavior
Number of left dimensions Preserved from the QlikView NumberOfLeftDimensions setting. When not specified, a heuristic is applied: all dimensions except the last are placed on the left.
Totals position QlikView TOTAL_AT_TOP maps to qShowTotalsAbove=true. QlikView TOTAL_AT_BOTTOM maps to qShowTotalsAbove=false. Per-dimension subtotals are enabled when totals are active.
Indent mode The hierarchical indentation setting is preserved.
Always fully expanded The initial expansion state is preserved.
Null symbol Custom null symbols are preserved.
Pseudo-dimension styling The QlikView pseudo-dimension row style (used for measure name headers in pivot tables) is converted to the Qlik Sense measureLabels theme section. Font color, background, font style, font family, and font size are preserved.
Row and column assignment Dimension and measure component IDs are mapped to the Qlik Sense pivot table layout structure, which assigns each dimension to either the row or column role based on the left dimension count.
Cell styling See the table styling section below.

Table styling

The following cell styling properties are preserved for both straight tables and pivot tables.

Property Conversion behavior
Header style Font color, background color, font style (bold, italic, underline), font family, and font size are preserved.
Dimension cell style Font color, background color, and font styling are preserved for the first dimension cell variation.
Measure cell style Font color, background color, and font styling are preserved for the first expression cell variation.
Total row style Font color and background color for total rows are preserved. QV2QS prefers the header total style and falls back to the dimension total style.
Null cell background The dimension cell background color is applied to null value cells. When no dimension background is defined, white is used.
Cell background alpha QlikView alpha values (0 to 255) are pre-blended against a white background. Qlik Sense table cells do not support alpha transparency, so the visual result is an opaque pre-blended color. Fully transparent cells (alpha 0) have the background removed.
Border color and alpha Grid border and divider colors are preserved. The alpha value is normalized from the 0-to-255 range to a 0-to-1 decimal.
Vertical border mode When the QlikView vertical border mode is BORDER_NONE, vertical dividers are removed from the Qlik Sense table.
Zebra striping When the QlikView stripe interval is 2 or greater, alternating row colors from CellVar[0] and CellVar[1] are applied. Background alpha blending is applied to both stripe colors.
Font mapping QlikView font names are mapped to the closest available Qlik Sense font. Font sizes are snapped to the nearest allowed Qlik Sense theme size (10 to 24 pixels).

Non-chart objects

Filter pane (listbox and multi-box)

Property Conversion behavior
Field name The listbox field or calculated dimension expression is preserved.
Title and subtitle Mapped from the QlikView caption and title. Multi-box titles are applied per child.
Show frequency The frequency display mode (none, values, or percent) is preserved.
Text alignment Right and center alignment are preserved. Left alignment is the default.
Multi-column layout Multi-column listboxes are converted with grid data layout. The fixed column count is preserved. When a fixed column count is set, the layout order is forced to row. When no fixed column count is set, the row-first or column-first layout order is preserved from QlikView.
Checkbox mode When enabled, the listbox uses checkbox selection with dense layout.
Sort criteria Per-field sort criteria are converted. Date-like fields optionally suppress state-based sorting.
Cycle and drill groups Listboxes bound to cyclic or drill-down groups are wired to the corresponding master dimension. The title expression uses GroupDimensionLabel() to display the active field name.
Background and theme Listbox background colors (including alpha) are applied to the filter pane theme. Transparent backgrounds are explicitly set to prevent Qlik Sense theme defaults from overriding. Title font colors are preserved with a contrast check against the background. Content font colors are preserved as-is.

Action button

Property Conversion behavior
Label text The button label is preserved. Text objects promoted to action buttons use the text expression or caption text as the label.
Navigation action Navigation to a sheet, chart, or URL is preserved. Same-window navigation is converted where applicable.
Variable actions SetVariable actions are preserved as button actions.
Text color Static RGB text colors and dynamic text color expressions are both preserved. For text objects promoted to buttons, the QV text color is converted.
Background color Static RGB background colors with alpha transparency are preserved. Dynamic background color expressions are preserved.
Transparency When the QlikView alpha value is 0 or the background mode is not solid, the Qlik Sense button background is forced to fully transparent. The transparent setting prevents Qlik Sense theme defaults from overriding the intended appearance.
Button image QlikView button images (BS_IMAGE style) are converted using media URL placeholders. The actual media file URL is resolved during cloud deployment.

Actions that cannot be mapped to Qlik Sense equivalents are listed in the conversion report. The object is flagged for manual review when unsupported actions are present.

Variable input

Property Conversion behavior
Variable name The bound variable name is preserved for both slider and input box sources.
Slider properties Slider minimum, maximum, and step values are preserved when the input style supports auto mode.
Render mode QlikView slider input styles map to Qlik Sense render modes: slider style maps to slider mode, other styles map to input field mode.
Predefined values Input box predefined values are converted to a dropdown list. Each value and the corresponding display label are preserved.

Date picker

Property Conversion behavior
Calendar field The field used for date selection is preserved. For sliders, the field is extracted from the variable configuration.
Single or range mode The QlikView calendar selection range setting determines whether the date picker uses single date or date range mode.
Date bounds Minimum and maximum date expressions are generated from the calendar field using Min() and Max() functions.
Title The title and header settings are preserved. When the date picker requires manual adjustment (for example, a variable-bound slider without a clear field source), the title is overridden with a visible marker for review.

Text object

Property Conversion behavior
Body text Text expressions (starting with =) are added as hypercube measures. Static text is rendered directly.
Caption text When the caption is shown, the caption maps to the Qlik Sense title with showTitles=true.
Text color Static RGB text colors are applied to the text format style. Dynamic text color expressions are applied as attribute expressions on the hypercube measure, enabling runtime color evaluation. Constant color expressions (for example, RGB(255,0,0)) are detected and applied statically.
Font styling Bold, italic, underline, font size (points to pixels), and font family are converted to CSS format style properties on the text document.
Background color Solid background colors with alpha are applied to the general component. For text objects, background color expressions are also supported.
Caption overlay When a text object has a styled caption bar with content below, QV2QS creates a separate overlay sn-text object for the caption. Empty lines are prepended to the body text to push content below the overlaid caption. The overlay height is estimated from the caption font size (point size multiplied by 1.5 plus 8 pixels).
Text objects with actions Text objects that contain button actions or navigation are promoted to action buttons. The text expression or caption text becomes the button label.

Shape (line and arrow)

Property Conversion behavior
Orientation Horizontal and vertical orientations are preserved. Unrecognized orientations default to horizontal.
Line weight QlikView line weight values are scaled to the Qlik Sense 1-to-20 pixel range using the formula round(weight / 4), clamped to a minimum of 1.
Dash settings The dash enabled flag, dash segment length, and dash gap spacing are preserved.
Stroke color Static RGB stroke colors are preserved.
Color by expression Dynamic stroke color expressions are preserved as Qlik Sense expression objects. When color by expression is active, the static color is not used.

Statistics box

Property Conversion behavior
Statistical functions All 15 QlikView statistical functions are converted: Total count (Count), Sum, Average (Avg), Stdev, Skew, Kurtosis, Min, Max, Numeric count (NumericCount), Null count (NullCount), Text count (TextCount), Missing count (MissingCount), Only, Median, and Fractile.
Display order The QlikView canonical display order is preserved: count variants first (Numeric count, Null count, Text count, Total count, Missing count), then Sum, Average, Stdev, Skew, Kurtosis, Min, Max, and Only. Fractile and Median rows are appended after the main statistics in the order defined in the source.
Custom labels When a QlikView statistics box uses custom labels, the custom label replaces the default label. When the custom label is empty, the default label is used.
Fractile and Median Fractile values are parsed from hex-encoded IEEE 754 doubles in the QlikView XML. A fractile percentile of 50% is labeled as Median. Multiple fractile rows are supported (for example, 25th, 50th, and 75th percentiles).
Background color The scroll background color is applied to the general component.
ValueList pattern The statistics box is converted to a table using one dimension and one measure. The dimension uses ValueList() with all enabled statistic labels. The measure uses a nested If(ValueList()='Label', Expression, ...) chain to dispatch to the correct aggregation function per row. Sort by load order preserves the original display sequence.

Container (tabbed)

Property Conversion behavior
Tab labels Container member labels are extracted from label expressions.
Active tab The default active tab index is preserved.
Tab order Member order follows the original QlikView container member order.
Child objects Each tab member is rebuilt as a child object within the Qlik Sense tabbed container. Child object titles are hidden to avoid duplication with tab labels.
Background color Container background colors with alpha transparency are preserved on the general component. Background color expressions (including RGB-to-ARGB conversion for separate alpha values) are supported.
Nested containers Containers nested inside other containers are supported up to 8 levels deep. Grid-mode nested containers produce layout containers. Tabbed nested containers produce recursive tabbed containers.

Container (grid mode)

Property Conversion behavior
Grid dimensions The row count and column count are preserved.
Title The container title, subtitle, and footnote are preserved from the base object.
Child placement Child objects are placed within the layout container grid at the original positions.

Learn more

Visit the discussion forum at community.qlik.com

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!