Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Showing results for 
Search instead for 
Did you mean: 

Columns disappear in the chart when clicked. Error in aggregation?


Hi there!
There is an Excel table with data and I want to visualize it in QlikView as a chart.
(Excel file description: all names are conditional, for example. Status "-1", " 1 " to display the current Qlik
data: "-1" - not active, " 1 " - active)pic6.JPG



In Qlik I want to see in the chart columns with "Criterion 1" by "Object", only active ( "1" ).
Used such dimension:

The expressions look like this:

Status)),[Criterion 1],[Criterion 2],[Criterion 3],
[Criterion 4],[Criterion 5], Type,[Criterion Object],DateChange,
Status,DescriptionChange)>0, 1))>0,1)

Problem: If the string "Criterion 5" has a null value, clicking on the column values "Object"-
lost "Criterion 5" and "Object" columns.

Maybe an error in the aggregation expression? What you think?

Labels (2)
0 Replies