topic Re: Greater than logic on Pivot Table in QlikView

Greater than logic on Pivot Table

Fri, 10 May 2013 03:29:27 GMT

Hey Developers - I have a problem

I need to be able to change the background colour if the participation rate on the week / month post the previous week / month is greater in green or red if below.

Cannot seem to get the expression right ?

Any help will be much appreciated

Using : =If( Column(0)>Column(1), LightRed(), Green()) at the moment.

Re: Greater than logic on Pivot Table

Fri, 10 May 2013 05:00:32 GMT

well there is nthing like column(0), u start with column(1), it might help.

But still i dnt understand which columns u wish to comapre in the screenshot and where do u want green/red.

please explain.

Regards

Re: Greater than logic on Pivot Table

Fri, 10 May 2013 05:03:34 GMT

Hey there - thanks for the response.

Sorry Typo !

I ended up using - =if(Count ([TOTAL CHARGES])>= Before( Count ([TOTAL CHARGES])), LightGreen(), LightRed())

and it worked.

I wanted to compare the next column with the previous column in the PIVOT table.

Re: Greater than logic on Pivot Table

Fri, 10 May 2013 05:25:34 GMT

Yes, using 'below' would solve your solution