Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator III
Creator III

dynamically change %

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.

3 Replies
Not applicable

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

senpradip007
Specialist III
Specialist III

PFA

surajap123
Creator III
Creator III
Author

Hi Pradip,

Thanks for the help.

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