Using variable with parameter within a variable with parameter

[#1]

Hi all:

Can anyone teach me how to do this or is this actually working?

Let's say I have a variable called 'vKPI_a' which contains a formula to calculate the KPI and it take one date related parameter.

I would have other KPIs like vKPI_b, vKPI_c ...

For example, if you want month to date KPI, then you use this variable like: $(vKPI_a('MTD'))

And then I want to create another variable for colour coding, say 'vColourCoding'.

In this variable, the formula would be like:

IF($1 < 0.5, RED(), IF($1 < 0.8, YELLOW(), GREEN())

So how can I use the KPI variable as a parameter for the colour coding variable?

I would assume it will look like: $(vColourCoding($(vKPI_a('MTD')))). But it does not work...

Thank you very much.

Paco

[Kushal_Chawda]

It will be difficult to understand from the explanation. Please post the sample app

[sasiparupudi1 · Accepted solution]

Try this post , you should get your answer

https://community.qlik.com/message/534440#534440

Sasi

[#4]

Thank you very much!