topic Re: Set Analysis : Finding a way to calculate selected week vs previous week in QlikView

Set Analysis : Finding a way to calculate selected week vs previous week

Fri, 03 Oct 2014 19:16:56 GMT

Hi All,

I'm trying to develop a set analysis expression where a user clicks on a specific week in a list box in date format, and then a text box automatically calculates a Week Over Week analysis based on the selected week vs the previous week.

Example : User clicks on 8/18/2014. A text box would show the percentage difference between the selected week and the previous week in regards to sales.

Is this possible? Is Set Analysis the best to use in this case?

Re: Set Analysis : Finding a way to calculate selected week vs previous week

maxgro — Fri, 03 Oct 2014 19:33:51 GMT

yes it should be possible with set analysis

something like (for this week)

=sum({<date={">=$(=WeekStart(max(date)))<=$(=WeekEnd(max(date)))"}>} sales )

Re: Re: Set Analysis : Finding a way to calculate selected week vs previous week

Anonymous — Fri, 03 Oct 2014 19:46:29 GMT

Take a look on the attached file.

In this case you will need to create a new dimension with the week.

Regards,

Gabriel

Re: Set Analysis : Finding a way to calculate selected week vs previous week

Fri, 03 Oct 2014 23:47:03 GMT

Thank You! I simply added a -1 to your expression and it worked perfectly! I really need to engage and understand Set Analysis more