topic Re: Variable as field name in set analysis in QlikView

Variable as field name in set analysis

Fri, 09 Jan 2015 15:20:57 GMT

Dear all,

I have the following Issue:

I created a variable "vYear" and this variable contains a flag from the master calendar. (e.g. vYear = "CY" (which represents the current Year)).

I used to have the following Expression which worked fine for me and calculates the total sales of the current year:

Sum({1<CY = {1} >} Sales.Amount)

Now I want to replace the "CY" with the Variable "vYear". As far as I know only field names are allowed on the left Hand side of the modifier. I tried the following:

Sum({1<$(vYear) = {1} >} Sales.Amount)

Unfortunately, QV does not recognoze my variable as the CY field flag from the master calendar.

Is it anyway possible to use variables on the left Hand side of the modifier, if the result of the variable is a field Name?

Please help me with this, I hope this will work!

Thanks in advance!

Re: Variable as field name in set analysis

Anonymous — Fri, 09 Jan 2015 15:35:15 GMT

I tried with a simple test and I understand that you should define your variable without equal sign in the expression.

Try in this way, let me know!

Re: Variable as field name in set analysis

simospa — Fri, 09 Jan 2015 15:42:13 GMT

Did you try with:

Sum({1<$(=vYear) = {1} >} Sales.Amount) ?

Let us know 🙂

Simone

Re: Variable as field name in set analysis

Fri, 09 Jan 2015 15:44:09 GMT

Thanks for your quick answer!

Can you please write the Formular becuase I do not understand which equal sign you want to delete..

Thx!!

Re: Variable as field name in set analysis

Fri, 09 Jan 2015 15:44:42 GMT

Yes, i tried... unfortunately with the same result..

Thx

Re: Variable as field name in set analysis

Anonymous — Fri, 09 Jan 2015 15:47:20 GMT

In the attched qvw you can find two text objects that get same result, one with field CY, the other with varianle vYear.

Please, see the Variable setting in order to see that there is not = in the definition of vYear

Re: Variable as field name in set analysis

Fri, 09 Jan 2015 15:58:42 GMT

YES!!! Thank You!!!