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

Nkroof — Sat, 16 Nov 2024 04:44:53 GMT

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)

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:

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.

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

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

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