QlikView 12 Alternate states + variables + aggregation function

timmy — Wed, 29 Nov 2017 12:51:03 GMT

Hi All,

Note: If is speak about an application, I speak about an QV application

I have a small issue with an application when I open this application in 12.1.

I made an example application to explain my issue in more detail (see attachment).

First a few facts that are important to know:

In the application I have a variable that contains a simple if + match function.
I also have an aggregation function that uses the outcome of the variable as an aggregation level (for a dynamic use of this aggregation function)
I also use this function in different/alternate states.

My issue is as follows:

When I use the application in the 12.1 version, I need to make a small change in my variable. I need to delete the '=' sign because an old bug in the 11.2 version is now fixed in the 12.1 version. Deleting the '=' sign will give me the possibility to use the variable in different states now.

The issue start popping up when I use my aggregation function with the variable as dynamic aggregation level.

When I use this expression/calculation in a textbox (with changing the alternate states as needed), the formula works.
When I use the calculation in a chart expression, is doesn't work anymore.

If I go back to the 11.2 QV version and add the '=' sign again, it suddenly works again .

My question:

Is this normal behavior or a bug in the 12.1 version?

Kind Regards

Timmy

Re: QlikView 12 Alternate states + variables + aggregation function

Gysbert_Wassenaar — Wed, 29 Nov 2017 13:05:36 GMT

Try this expression in your chart: =Aggr(nodistinct Sum(Expression1),$(=$(vAggrLevel)))

Then get rid of that expression and use this one instead: Sum(total <$(=$(vAggrLevel))> Expression1)

Re: QlikView 12 Alternate states + variables + aggregation function

timmy — Wed, 29 Nov 2017 13:40:15 GMT

Hi Gysbert,

Thanks for the fast reply. Can you also give me an explanation why we should use $(=$(variable)) in the 12.1 version instead of $(=variable) in the 11.2?

Kind Regards

Timmy

topic Re: QlikView 12 Alternate states + variables + aggregation function in QlikView

QlikView 12 Alternate states + variables + aggregation function

Re: QlikView 12 Alternate states + variables + aggregation function

Re: QlikView 12 Alternate states + variables + aggregation function