topic Re: Set Analysis question in QlikView

Set Analysis question

john_duffy — Mon, 23 Jul 2012 17:18:57 GMT

Hello.

I have attached a sample application with 3 charts that provide the same values:

1 - Expression using an if statement

2 - Expression using set analysis with -= 0

3 - Expression using set analysis with > 0

When a value for Store Type is selected, why doesn't the 3rd chart (using > 0) drill down?

Thanks,

John.

Re: Set Analysis question

jcampbell — Mon, 23 Jul 2012 17:51:07 GMT

Set Analysis will not update on selections. That's the beauty of Set Analysis. So when you use Set Analysis the result of the expression should be unchanged regardless of selections made. In this case it should always display the expression results where the Store Type is > 0 AND the Store Loc = N. If you change the third Object to use the following Expression you will get the results you're looking for:

Sum({$<[Store Type] = {">0"},[Store Loc] = {"N"}>} Sales)

And this will be unchanged regardless of selections. It seems to me that the second Object needs some tweaking for the Expression. Unfortunately I'm not familiar with using -= (or NULL) in Expression or Set Analysis.

Hope the above helps.

Re: Set Analysis question

cesaraccardi — Mon, 23 Jul 2012 17:51:10 GMT

Hi John,

This happens because the modifier [Store Type] = {'>0'} overwrites the selection you made previously in the same field.

Regards,

Cesar

Re: Set Analysis question

cesaraccardi — Mon, 23 Jul 2012 17:57:32 GMT

When you use -= in the second chart, is the same as: [Store Type]=[Store Type]-{0}, the result is all selected store types excluding zero.

Re: Set Analysis question

mikecrengland — Mon, 23 Jul 2012 18:13:21 GMT

try this

Sum({$<[Store Type] *= {">0"},[Store Loc] = {'N'}>} Sales)

note the '*' after [Store Type]

Re: Set Analysis question

john_duffy — Mon, 23 Jul 2012 18:55:54 GMT

Thanks for your help guys.