topic Re: Conditional Formatting of a Sliders 'Text' in QlikView

Conditional Formatting of a Sliders 'Text'

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Weird one but couldn't find a solution!

I have a slider variable for details shown on a chart.

Slider Min: -100

Slider Max: 100

Now I was wondering if it was possible to make all negative values of the 'Text' in the slider be red.

Has anyone tried this before or got an alternative solution.

If you look at the below it is quite hard to identify the Negative Values!

Re: Conditional Formatting of a Sliders 'Text'

hallquist_nate — Tue, 28 Nov 2017 20:18:11 GMT

Hmmmmm... This is a good one. I don't think you can get the text to be red for negative values. However, you can probably set something up where the background of the slider is fully transparent, then put a red background behind the slider, or maybe a bar chart that can color in parallel with the slider values.

Good luck,

Nate

Re: Conditional Formatting of a Sliders 'Text'

craig157 — Wed, 29 Nov 2017 08:20:01 GMT

Great idea Nate!

Looks a bit sketchy but I will snazz it up!

Thanks

Re: Conditional Formatting of a Sliders 'Text'

hallquist_nate — Wed, 29 Nov 2017 18:53:39 GMT

That is what I was thinking you could do. It does look a bit sketchy, but you are definitely on the right trail.

Good Luck!

Nate