topic Re: Set Analysis in QlikView

Set Analysis

Tue, 30 Apr 2013 13:57:28 GMT

I used below set theory in a text box:

Sum( {<Year = {2011}>} Sales)

In the dashboard if I select :

1. Year as 2011. Sum of Sales displayed for 2011.

2. Date(s) of 2011. Sum of sales on those dates is displayed.

3. Year as 2012. Sum of Sales displayed for 2011.

4. Date(s) of 2012. 0 is displayed.

---------------------------------------------------

Suppose 2011 no sales in the month of dec,,,,,, but 2012 have data for dec as well.

---------------------------------------------------

5. Select Dec . 0 is displayed.

6. Any other month(s). Sum for that month in 2011 is displayed.

Can anyone kindly help me with valid justification for this behaviour of set analysis.

Thanks & Regards

Suhas Gupta

Re: Set Analysis

Gysbert_Wassenaar — Tue, 30 Apr 2013 15:17:29 GMT

In this expression Sum( {<Year = {2011}>} Sales) only the selection for field Year is fixed. It's fixed to the value 2011. This determines the set. The set is calculated first, after that the other selections are applied.

If you select dates in 2011 then the expression is applied to the selected dates that are part of the set. Dates in 2012 are not in the set calculated for Year = {2011}. So you get no result if you select dates in 2012.

If you select year 2012 then that selection is ignored because you specified Year = {2011} for the set. So you get the result for 2011 if you select 2012.

If you select Dec you get Dec 2011. If you select another month you get the sum for that month in 2011. Only Year was fixed in the set to 2011. Selections in the other fields are still applied.

Re: Set Analysis

Wed, 01 May 2013 07:09:23 GMT

here Year =2011 is fixed

so you can try this expression

=Sum( {$} sales)

sum({<year={"$(=year)"}>}sales)

Re: Set Analysis

er_mohit — Wed, 01 May 2013 07:16:54 GMT

if you want the data on selection then

as per your expression you fixed to 2011

try this

Sum({<Year={"$(=year)"}>}Sales)