Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

pedlopes
New Contributor III

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

Re: Compare the preview month with the current month on same day

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

pedlopes
New Contributor III

Re: Compare the preview month with the current month on same day

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.

Community Browser