Resolving a Paramter befor Variable expansion

daniel_werndl — Thu, 26 Jul 2018 12:59:20 GMT

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?

topic Resolving a Paramter befor Variable expansion in QlikView

Resolving a Paramter befor Variable expansion