topic Week This Month (W1) vs Week Last Month (W1) Comparison in App Development

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

tilakbhawsar094 — Sat, 16 Nov 2024 18:26:09 GMT

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.

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

raji6763 — Thu, 02 Jul 2020 09:34:05 GMT

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

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

tm_burgers — Mon, 03 Aug 2020 17:23:24 GMT

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