Week This Month (W1) vs Week Last Month (W1) Comparison

[tilakbhawsar094]

Hi All,

I have a requirement where client is asking for a bar chart where it shows week on week comparison.

For Example: If you see in the attachment, there are three fields Reporting Date, Values and Week Number. So, I want to compare Week1 of March month(3/7/2020) to Week1 of Feb month (2/7/2020) and likewise for all the weeks of that month as well as for all the months which are present.

if a month has W4 as well as W5 so that will compare with the W4 of last month.

Everything should be handled in front end only, can not perform in data model side means in backend.

Please provide your valuable help ASAP.

Please let me know if you have any doubts.

[raji6763]

hi @tilakbhawsar094 ,

your scenario is comparative analysis .you can achieve your scenario using Alternate states.please see the below link that will helps you

https://community.qlik.com/t5/New-to-QlikView/Simple-example-on-Comparative-Analysis/td-p/811019

regards,

raji

[tm_burgers]

Not sure if you have solved or not yet, but I would opt for dimension = reportdate.month. 

Measure, add 5.

If(day(reportdate) > 0 and day(reportdate) < 8, sum(value)) :label as W1

Etc. 

Thats the direction I would try since you can add the W1 dimension in the data backend