Set Analysis: Show minimum week value for each month

Mon, 11 Apr 2016 14:04:29 GMT

Hi Qlik Developers,

I'm facing an issue coming up with a Set Analysis expression to show inventory value for every month in a year (it should show minimum week for every month). When I use the below expression, it shows only value for January (1st week) but other months remain NULL or blank.

=if((Only([Month Number])), Sum({$<[Year]={$(=max(Total [Year]))},[Week Number]={$(=min(Total [Week Number]))}>} Inv_Units), Sum({$<[Year]={$(=max(Total [Year]))}>} Inv_Units))

Just an example:

The above expression showing only 1st week value for January and blank for others.

January 50

February -

March -

April -

and so on....

Where as I want to see values for each month (min 1st week for every month not only January)

January 50

February 45

March 38

April 12

and so on....

I thought of the below expression to achieve the desired results but this was also showing only January.

=if((Only([Month Number])), Sum({$<[Year]={$(=max(Total [Year]))},[Month Number]={$(=(Total [Month Number]))},[Week Number]={$(=min(Total [Week Number]))}>} Inv_Units), Sum({$<[Year]={$(=max(Total [Year]))}>} Inv_Units))

I would really appreciate your help!!

Thanks!

Vidit

Re: Set Analysis: Show minimum week value for each month

sunny_talwar — Mon, 11 Apr 2016 15:41:16 GMT

Would you be able to share a sample to look at?

Re: Set Analysis: Show minimum week value for each month

Mon, 11 Apr 2016 15:47:31 GMT

Hi Sunny,

I can't share much but here is a screen shot. If you see all other months are 0 but only feb shows value. We follow retail calendar so our first month is Feb (Just to clear out confusion).

Thanks!

Vidit

topic Set Analysis: Show minimum week value for each month in QlikView

Set Analysis: Show minimum week value for each month

Re: Set Analysis: Show minimum week value for each month

Re: Set Analysis: Show minimum week value for each month