topic Re: Baffling issue with simple set analysis in QlikView

Baffling issue with simple set analysis

sifatnabil — Tue, 03 Nov 2015 11:23:32 GMT

Hi all,

I have a chart with time on dimension and this simple set expression:

sum({<Product={'Product A','Product B','Product X','Product D'}>}Revenue)

For some reason, the chart doesn't change when I select a single product like Product A. Expected behaviour should be that the chart changes to show only Product A revenues. Any idea how this could happen? It doesn't seem to reflect any selection made on the Product listbox.

Re: Baffling issue with simple set analysis

MK_QSL — Tue, 03 Nov 2015 11:24:06 GMT

Use

sum({<Product *= {'Product A','Product B','Product X','Product D'}>}Revenue)

Re: Baffling issue with simple set analysis

sifatnabil — Tue, 03 Nov 2015 11:25:57 GMT

Thanks Manish - this works but why? Haven't seen this before.

Re: Baffling issue with simple set analysis

swuehl — Tue, 03 Nov 2015 11:27:14 GMT

That's because you override user selection in Product with a fixed list of porducts.

You need to use the set intersection operator * as Manish Kachhia suggested to keep your current user selections in the game.

Re: Baffling issue with simple set analysis

simenkg — Tue, 03 Nov 2015 11:27:48 GMT

Because the set analysis you wrote overwrites any selection in the field.

the *= modifier says to chose the Product that is both in the current selection and the specified list.

Re: Baffling issue with simple set analysis

sifatnabil — Tue, 03 Nov 2015 11:36:06 GMT

But I applied the same set analysis on another chart in the same sheet, with the same products, except it was

count({<Product = {'Product A','Product B','Product X','Product D'}>}orders) instead of sum. Why does it work here but not in the other chart?

Re: Baffling issue with simple set analysis

swuehl — Tue, 03 Nov 2015 11:41:13 GMT

Well, it shouldn't change, if this is the only aggregation in your chart.

Can you upload a small sample QVW?

Re: Baffling issue with simple set analysis

SreeniJD — Tue, 03 Nov 2015 11:41:36 GMT

I guess, Count and Sum works differently in the backend. Count just a need a pointer reference to count the record but Sum need to fetch the data so, it might not work

Sreeni