topic Set Analysis in QlikView

Set Analysis

Anonymous — Fri, 13 Dec 2013 14:24:36 GMT

I want a straight table that shows weekly sales and monthly sales. When 1 week is selected how do I get the monthly column to show the sales for the whole month to which the week belongs.

Thanks

Re: Set Analysis

Gysbert_Wassenaar — Fri, 13 Dec 2013 14:30:09 GMT

Something like this if your fields are named Week and Month:

sum({<Week=, Month={'$(=max(Month))'}>}Sales)

If you have data for multiple years you might need to add the year to the set modifier too. Something like Year={'$(=max(Year))'}

Re: Set Analysis

Anonymous — Fri, 13 Dec 2013 14:52:13 GMT

Thanks very Much