Why need aggregation for a dynamic bar-chart/ table
I'm using a variable like vFormula='0'. I'm using it so that I can switch a bar chart and a table dynamically between two count condition for example with a qlikswitch or a button where I can implement '0' or '1' from the variable. These two conditions for the bar chart/ table dimension are:
Can anybody please explain why the "simplier" straighforward one without agg() returns zero and doesn't work like this one? Why I need aggregation to make it work?
Also instead of EndingDate at the end I also tried directly with weekname[EndingDate)], and that also gives me zero returns. Seems like I need to take the "original "EndingDate" without weekname function.
thanks for the quick reply. Somehow its still not very clear to me.
You said in case I want to "leverage" the dimension I need to aggregate. That would suppose my case is already a "leverage" case? So how is that defined? Can you explain more deeply whats happening there? Actually when I don't do this I get zero returns.
In simple way to explain my misunderstanding here. Didn't I already fullfill the typical if -statement when that happened:
if vFormula is 0, then count me the first condition, otherwise the second condition, and when I have results greater then 0 then give me the EndDate in Calendar week form.
Isn't the calendar week is already the return I get? Why do I have to put again a EndDate aggregation
You also brought me to the realization, that I don't need this aggregation with the second if-statement for my measures , only for my dimensions.