Parameters to variable with alternate states

Thu, 26 Mar 2015 08:34:38 GMT

Hi, I'm trying to create a variable that I can use for computations either with or without alternate states.

So far I have come up with the following (vSales):

If(
  $1=Null(),
  Sum(Sales),
  Sum({$1} Sales )

The thing is that it seems to work when I supply the state names. However, it messes up the charts where I have a drill-down group but where I don't use alternate states. When I click on the chart where I don't supply alternate state names to the variable I don't drill down to the next level but rather get to see everything, also stuff that does not belong to that group.

I know that drill-down groups don't work with alternate states but I had thought the variable expression I have should not care about that when I supply $(vSales()) to the chart because it does not contain a reference to an alternate state in the set analysis. The charts where I write $(vSales(State1)) seem OK although I have not done detailed validation because I cannot get past this issue.

I could create variables for each state but I find that to defeat the purpose of having all computation details tucked neatly into variables. The code would be identical except for the set analysis.

Any ideas?

Unfortunately, I cannot send my QlikView file because it contains sensitive data.

topic Parameters to variable with alternate states in QlikView

Parameters to variable with alternate states