Depending on an if-condition, data is selected or no data is selected
I would like to use an if-condition in a variable to calculate, if i need set analysis or not. So the set analysis is supposed to include a field selection or there is no field selection at all, depending on the if-condition in the variable.
Here is my calculation in the chart:
The variable in that sum is defined as follows: vWeek =if(GetSelectedCount(Week)>0, max(Week), '*')
But everytime QlikView interprets the * as some text and does not show anything at all, because the field Week includes values from 1 to 52.