topic Re: Color formating with date value in QlikView

Color formating with date value

AndreasGu — Fri, 15 Nov 2024 23:34:22 GMT

I'm quite new to Qlik and trying to understand how the if statements work together with date sets.

I have two date ranges. Last 7 days (day 1-7), and the previous 7 days (day 8-14).

So here I try to see which one is the higher, what amendments needs to be made here?

if(sum({_Last7Days} #SALES) > sum({_LastPR7Days} #SALES) , green(), red())

Re: Color formating with date value

MayilVahanan — Wed, 25 Nov 2020 02:42:49 GMT

Hi @AndreasGu

I think, you have 2 flag field like _Last7Days & _LastPR7Days in your calendar. In that case, try like below

if(sum({<_Last7Days ={1}>} #SALES) > sum({<_LastPR7Days={1}>} #SALES) , green(), red())

Re: Color formating with date value

AndreasGu — Wed, 25 Nov 2020 12:43:51 GMT

Thank you. That sorted it.