Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare the preview month with the current month on same day

Hi guys,


Anyone know how i built a expression to compare the preview month with the current month on same day?

Exemple:

Today is 24 of October and i have sales from 1 to 24 October 200.000$

I want compare this sales to last month on the same day.

24 of September vs 24 October.

Thanks in advance,

Pedro Lopes

2 Replies
sunny_talwar

Try reading about The As-Of Table here and see if this helps

Anonymous
Not applicable
Author

Thanks Sunny for this link.

How can apply this method on my case?

Concretely i want create 3 measures on my dashboard:


1 -  Compare this year vs last year until now ex: [01-jan-2015 to 02-nov-2015] vs [01-jan-2015 to 02-nov-2015]

ex: YTD vs YTD (year-1) ??

2 - Compare this month vs last month until now ex:[01-oct-2016 to 02-oct-2016] vs [01-nov-2016 to 02-nov-2016]

ex: MTD vs MTD (month-1)





3 - Compare last day loaded (yesterday) vs (yesterday-1) ex: [31-oct-2016] vs [01-nov-2016]

ex:

- yesterday ---- sum({1<date_id={">=$(=Max(date_id))"}>}N_of_downloads ) ...works.

-yesterday  ---- sum({1<date_id={">=$(=Max(date_id)-1)"}>}N_of_downloads ) ...didn't work.






My master calendar is on this format:

Dim_Date:

LOAD

    date(F1,'YYYYMMDD') as date_id,

    "Day",

    "Week",

    Week_day,

    "Month",

    "Year",

    MonthYear

FROM [.....]

(qvd);

where date_id >= $(vMinDate) and date_id <= $(vMaxDate);


Thanks in advance.