Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Nkroof
New Contributor

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:

pic1.JPGpic2.JPG
The expressions look like this:

If(Sum(if(Aggr(Sum(if(Num(DateChange)<=Num('$(ActualDate)'),
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.

pic4.JPGpic5.JPG
Maybe an error in the aggregation expression? What you think?

Tags (2)
Labels (2)