topic Re: dynamically change % in QlikView

dynamically change %

surajap123 — Thu, 25 Sep 2014 11:28:48 GMT

Hi Experts

I want to set red color to % column values (last column in straight table) when the values are greater than a given percentage(say >10%) and then allow the user to change the percentage using slider and want to set initially 10% by default.

I hope i can do this by creating a variable, but not sure.

Pls help.

Re: dynamically change %

Thu, 25 Sep 2014 11:36:12 GMT

Hi Suraj

First you need to creat a variable

LET vPrctg = 10;

Use "input field" object to display your variable

There is the place where the user can miodify value vPctg.

Use $(vPctg) in your table in background color for your considerated field like

if (YourFieldPctg) > $(vPctg), green(), red()

best regards

Chris

Re: dynamically change %

senpradip007 — Thu, 25 Sep 2014 11:38:56 GMT

PFA

Re: dynamically change %

surajap123 — Thu, 25 Sep 2014 11:53:30 GMT

Hi Pradip,

Thanks for the help.

But, your app doesnt contain the slider to change the percentage dynamically.