Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using variable with parameter within a variable with parameter

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

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

3 Replies
Kushal_Chawda

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

sasiparupudi1
Master III
Master III

Try this post , you should get your answer

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

Sasi

Not applicable
Author

Thank you very much!