Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Greater than logic on Pivot Table

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.

image002.png

1 Solution

Accepted Solutions
Not applicable
Author

Yes, using 'below' would solve your solution

View solution in original post

3 Replies
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

Yes, using 'below' would solve your solution