Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
singbittoo
Creator
Creator

Qliksense Pivot Table Color formatting

i have a  pivot table and in dimesion i am showing country, in columns i an showing months, and in the measure sum of sales,

my requirement is like if previous month sales is more compared to this month the color should be red else green

eg:

Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9
month 1month 2month 3month 4month 5month 6month 7month 8
India2123202526282622
canada
322146566675667

so for this i wrote an expression like

if(Before(sum(Sales),1)<sum(Sales),'Green','Red'), it is working for most of the cases but failing many places.

any solution ?

1 Solution

Accepted Solutions
singbittoo
Creator
Creator
Author

sorry, the above expression works fine my bad i had 4 expression which gets selected based on some condition, but in formatting condition i only wrote condition based on one expression

View solution in original post

1 Reply
singbittoo
Creator
Creator
Author

sorry, the above expression works fine my bad i had 4 expression which gets selected based on some condition, but in formatting condition i only wrote condition based on one expression