topic Re: Use Pivot dynamic Label as Parameters in QlikView

Use Pivot dynamic Label as Parameters

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all Gurus,

I set up a Label in Pivot as a formula to dynamically display my selection.

Now I want to use it as a parameters in an expression. Can anyone please show me the way to put it?

Example: I want to use the result of Year 2012 as a parameter in a sum. How to put ='Year'&' '&(max(Year)-1) in another expression?

Re: Use Pivot dynamic Label as Parameters

olivierrobin — Wed, 05 Sep 2018 07:15:02 GMT

hello

why don't you use the notation column() in your sum ?

suppose column Year 2012 is 4th column of you chart, then you can code sum(column(4))

Re: Use Pivot dynamic Label as Parameters

Anonymous — Wed, 05 Sep 2018 07:31:04 GMT

Hi Olivier,

The number of column is variable. I use conditional to hide/unhide to add up or deduct the columns I want. So the number of order is not fixed.

Any suggestion in this case?

Re: Use Pivot dynamic Label as Parameters

olivierrobin — Wed, 05 Sep 2018 07:44:32 GMT

and did you try to use the $(=) notation ?

something like

=$(='Year' & max(...))

Re: Use Pivot dynamic Label as Parameters

Anonymous — Wed, 05 Sep 2018 08:07:05 GMT

I tried to put it in several ways with dollar sign but didn't work

Re: Use Pivot dynamic Label as Parameters

jonathandienst — Wed, 05 Sep 2018 08:15:30 GMT

>>I want to use the result of Year 2012 as a parameter in a sum.

That's a little vague. I suggest you provide more specific information, including information on the underlying data, the expression(s) you have tried and what result(s) you need.

>>I tried to put it in several ways with dollar sign but didn't work

What did you try? Its hard to help debug an expression that is not shared.