topic Re: Checking alternative rows in a straight table in QlikView

Checking alternative rows in a straight table

Thu, 21 Aug 2014 11:50:19 GMT

Hi Friends,

I need to check alterantive rows of a straight table.

x y a b u v

1 1 2 2 4 7

3 3 3 3 7 8

if x and y are equal they should be in green or red.

if a and b are equal they should be in green or red.

if u and v equal they should be in green or red.

Here uv table should be red.

Please help

nirav_bhimani — Thu, 21 Aug 2014 11:57:27 GMT

HI,

You need to expand your Dimension if it is in the dimension or expression & then select Text color, write your condition in definition.

Regards,

Nirav Bhimani

Thu, 21 Aug 2014 12:01:08 GMT

Pavan, You requirement is confusing a bit. Can you clarify

Thu, 21 Aug 2014 12:09:12 GMT

Hi,

Please find the attached document for sample application.

Regards,

Vivek

saradhi_it — Thu, 21 Aug 2014 12:27:10 GMT

I think nirav.bhimani is correct i hope it works ............

Fri, 22 Aug 2014 12:25:23 GMT

Just create the expressions for Background Color & Tesxt Color after expanding the Dimension "+" on Dimension tab.