topic Pie chart for previous week in QlikView

Pie chart for previous week

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement to create a pie chart showing the total user count according to the POD name week wise.

I have closing dates of the user count.

The week ending should be Friday and the total user count for the week from sat-Fri should be displayed in the chart.

It has to dynamically change next week.

please give solution for this.

woshua5550 — Fri, 17 Nov 2017 10:21:52 GMT

Not sure but hope this could help you

if I misunderstood you plz let me know

calexandru — Fri, 17 Nov 2017 10:35:10 GMT

Hi Dhivya,

This is far from the most elegant approach but you could you set analysis to solve your issue, something along the lines of:

Count(DISTINCT {$<DateField={">=$(=WeekStart(Today()-7))<=$(=Date(Weekstart(Today() - 7)+4))"}>}Users)

With regards,

Alex

Anonymous — Fri, 17 Nov 2017 11:20:56 GMT

Thank you...

It worked well:)

Anonymous — Fri, 17 Nov 2017 11:22:16 GMT

Thank you for ur reply:)

But I wanted the data for the previous week to be loaded in the pie chart dynamically:)