Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Use Pivot dynamic Label as Parameters

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?

eg.PNG

5 Replies
olivierrobin
Specialist III
Specialist III

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))

Anonymous
Not applicable
Author

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?

olivierrobin
Specialist III
Specialist III

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

something like

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

Anonymous
Not applicable
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

>>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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein