This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
Try this post , you should get your answer
View solution in original post
It will be difficult to understand from the explanation. Please post the sample app
Thank you very much!