Sets Analysis Query

[shyamcharan]

Hi,

Can anyone please explain what point I miss in understanding the difference between '1' and '$' Identifier.

Please find the attached QVW document with a selection on the company.

I am expecting the Sum({$<Company = {'A','B'}, Year = {2011}>} Sales) value to be 2 rather than 8.

Thanks heaps in advance.

Regards,

Shyam.

[shyamcharan]

Hi Dushan,

Yes you are correct.

But when I make a selection on the company and select A or B i should get 6 or 2 but not 8 correct?

Please correct me wherever required.

[danieloberbilli]

additional: the Company=A,B,  has an effect...its infact the effect why you don't get the 2 but the 8 instead...QlikView selects A AND B

[#4]

Hi Shyam,

Then you have to change your expression like this

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

[#5]

sum({<year={2011}>}sales)    u  will get

go like this and check it

Sum({1<Company = {'A','B'}, Year = {2011}>} Sales)

[#6]

sum({<year={2011}>}sales)    u  will get       for indidual

go like this and check it

Sum({1<Company = {'A','B'}, Year = {2011}>} Sales)             for   8 

[shyamcharan]

Thanks Daniel.

So from what I did so far,

I have Company ={'A','B'}.Year={2011} in the set and I have made a selection on the Category list box as Category=1. Then I can see the change.

But wondering now why the Company values in the sets is excluded.

Regards,

Shyam.

[danieloberbilli]

Beware that what you see in white/grey/green in the qlikview listboxes do not always have an effect on all your calculations...as I said, if you explicitly use these fields in Set Analysis - every user selection by Listbox might ignored (depending on what you define in set analysis)