Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Show YTD,MTD,WTD on the same table

Hi,

I am stuck i  have to show the DAY,  YTD, MTD, WTD sales and repurchases on one table with the totals. This is based on the date date that the user selects, so if the user selects a date from a year a go then the year to date would be the year prior to the date the user selected.

periodDAYWTDMTDYTD
Sales23245646575654
Purchases-15-68-323-6466
Total7177614269188

I require this to be done using qv10 but if there is a big improvement in using qv11 then i may be possible for me to use it.

Thanks

Tags (2)
1 Reply
Not applicable

Re: Show YTD,MTD,WTD on the same table

Set statement like this.

YTD:

Sum({<Date={'>=$(=(Num(YearStart(Max(Date)))))<=$(=(Num(Date)))'}>}Amount)

MTD:

Sum({<Date={'>=$(=(Num(MonthStart(Max(Date)))))<=$(=(Num(Date)))'}>}Amount)

WTD:

Sum({<Date={'>=$(=(Num(WeekStart(Max(Date)))))<=$(=(Num(Date)))'}>}Amount)

Community Browser