topic Re: Trouble with Set Analysis in QlikView

Trouble with Set Analysis

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

Hi,

I have a table where I use the following expression with the {1} operator to prevent the data from changing when filter selections are made.

Count({1<Ex_Flag={'Excluded'},[HW Lifecycle Status] -= {'Disposed'}, [SW Lifecycle Status] -= {'Disposed'} >} SW_CI_ID)

This seems to work fine. But I also have the following expression in the background color of one of the dimensions to do some color coding.

=if((V_Class) = ('High'),rgb(255,0,0),
if((V_Class) = ('Medium'),rgb(255,217,47),
rgb(69,234,21) )

When I use make a filter selection, the data remains the same, but the background color coding changes/

How do I apply the {1} operator to the Background Color Expression?

sunny_talwar — Mon, 11 Apr 2016 20:54:12 GMT

Try this:

=If(Only({1} V_Class) = 'High', RGB(255,0,0), If(Only({1} V_Class) = 'Medium', RGB(255,217,47), RGB(69,234,21)))

brf10043 — Mon, 11 Apr 2016 20:59:20 GMT

That worked perfectly! Thanks Sunny

Anonymous — Tue, 12 Apr 2016 09:36:20 GMT

Hi Bobby,

it will be useful to mark it "answered"

Cheers

Antonio

Anonymous — Tue, 12 Apr 2016 10:29:00 GMT

Hi bobby mark correct answer and close this post...

brf10043 — Tue, 12 Apr 2016 12:44:14 GMT

Apologize for that!