topic Re: Pivot table in QlikView

Pivot table

upaliwije — Thu, 04 Aug 2016 06:23:36 GMT

I have follwing Pivot table in my Ducument

I want apply above colour scheme if Amount in June Column < Amount in May Column (green) otherwise red

Pls help me to do it

I have wirtten it Text Colur of Expression like this =if(match(MONTH,'Jun') , lightRed()) But I do not know how to do it both ways,

karthikoffi27se — Thu, 04 Aug 2016 07:12:32 GMT

Hi Upali,

In your Pivot Table, In the Expression window expand your Text Color box and enclose the below Definition.

=If(Sum({$<Month={'Jun'}>}Amount)<Sum({$<Month={'May'}>}Amount),Green(),Red())

Many Thanks

Karthik

Anil_Babu_Samineni — Thu, 04 Aug 2016 07:59:59 GMT

Perhaps This...!

vNetRange = Sum(NET_RANGE1)

=Aggr(If($(vNetRange) <= 10000, Green(),

If($(vNetRange) > 10001 and <=500000, Red(),

Black())),NET_RANGE1)

boopeshj — Thu, 04 Aug 2016 08:32:13 GMT

Please find the code and the screenshot.

I have used the data you provided.

if( Month='Jun',

if(before(sum(Data))>sum(Data),green(),lightred()

black())

Note : the Before would work only on a PIVOT table.

Regards,

Boo

Please mark correct answers if you find them.