Need Help??

Nagaraju_KCS — Mon, 22 Sep 2014 14:14:21 GMT

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....

Re: Need Help??

Nagaraju_KCS — Mon, 22 Sep 2014 17:54:01 GMT

Help me Please ..............!!

Josh_Good — Mon, 22 Sep 2014 18:05:54 GMT

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).