Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
daniel_werndl
Partner - Contributor
Partner - Contributor

Resolving a Paramter befor Variable expansion

Hi,

The given example is a simplified version of the problem. I dont need a solution for the actual task - so please no workaround answeres - Just is this possible, and why not?

I have a Pivot Table with Months as its Columns(numeric).

i've set a variable in the Document Options:

     vShowParam: sum({<Month={$1}>}Value)

The Variable is called inside the Chart:

     $(vShowParam(Month))

Now, it seems like the variable will always be expanded/evaluated outside the context of my chart.

Meaning Month is independent of the char Column 'Month' at the time of evaluation. So Month is always 12

I tried the following:

=$(vShowParam($(=num(Month))))

Results to:      vShowParam: sum({<Month={-}>}Value)


=$(vShowParam($(=num(max(Month)))))

Results to:      vShowParam: sum({<Month={12}>}Value)


=$(vShowParam(num(max(Month))))

Results to:      vShowParam: sum({<Month={num(max(Month))}>}Value)

Is it possible to have a Parameter resolve inside the Context of the Chart before evaluating the Variable?

My current solution is (works, but there must me a clearer Solution!):

if(Month = 1, $(vShowParam(1))

,if(Month = 2, $(vShowParam(2))

Any Ideas?

0 Replies