topic Re: pivot table expression in QlikView

pivot table expression

Tue, 17 Sep 2013 08:51:27 GMT

Hi,

I need a help with expression, I would like to have in pivot table only rows, where sum of row in pcs (ks) is bigger than certain value, for example 10.

Another question : how to do conditional formatting without formatting of total column. It is possible?

Re: pivot table expression

er_mohit — Tue, 17 Sep 2013 08:56:12 GMT

in expression tab where you add expression you see + icon expand it for that expression field you 'll see the background color and text format etc put your condition here

like for background color

if(your expression >10,green(),rd())

hope it helps

Re: pivot table expression

vikasmahajan — Tue, 17 Sep 2013 09:01:37 GMT

Go to expression -> Background Color ->

you can put conditions like following

=if(column(3)>0.001 and column(2)>0.001,if(column(3)>column(2),rgb(0,182,0),rgb(247,247,247)),0)

to display particular column in specific colour.

Hope this help u

Vikas

Re: pivot table expression

Tue, 17 Sep 2013 09:09:55 GMT

thanks, maybe I describe it in bad way, but actually I have only 2 columns and I need to remove conditional formatting from total column, which is on the left side of table