Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Need Help??

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

2 Replies
qv_testing
Specialist II
Specialist II
Author

Hi MarcoWedel


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

Josh_Good
Employee
Employee

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