This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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 ?
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