Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
PFA,
I have 3 expressions Like
FTD --> Sum({<Date={'$(=Today())'} Sales)
or Sum({<Date={'$(=Max(Date))'} Sales)
MTD---> Sum({<Date={'>=$(=MonthStart(Today()))'} Sales)
or Sum({<Date={'>=$(=MonthStart(Max(Date)))'} Sales)
YTD--->Sum({<Date={'>=$(=YearStart(Today(), 0, 4))'} Sales)
or Sum({<Date={'>=$(=YearStart(Max(Date), 0 , 4))'} Sales)
Same expression how to use in script level in one Bucket
i used like this..
LOAD *, If(Date=Max(Date), 'FTD',
If(Date>=MonthStart(Max(Date)), 'MTD',
If(Date>=YearStart(Max(Date),0,4), 'YTD'))) as Bucket;
But it showing error.. here used aggregation function we should use Group By Clause..
i have so many fields... how to use group by function...
If i am using Today() instead of this Max(Date)
Today()--> It showing only current year data.. if i am click 2013 it's not reflecting.
Thanks in Advance....
I am moving this posting to the QlikView area so you have the best chance of getting someone to help (not Qlik Sense is a different product).