topic Re: Error with filters in QlikView

Error with filters

venkey2847 — Tue, 07 Jun 2016 15:55:47 GMT

Hi All,

i have an filter

status
A
B
C

i have an one pivot table, it contains dimension which has same like my "STATUS" filter as with name status1.

Fields are same but names are different,like my filter is STATUS and my dimension is STATUS1.

i have an one measure in same pivot table like Sum({<status={'A','C'}>} sales)/Sum({<status={'A','C'}>} sales1).

whenever i selected my filter as B, my dimension should be show 'B' only.But my dimension showing B and A .

To get that output what i need to do?

Experts please help me out this issue.

Thanks in advance.

Thanks,

Venkey.

Re: Error with filters

sunny_talwar — Tue, 07 Jun 2016 16:40:02 GMT

May be this:

Sum({<status *= {'A','C'}>} sales)/Sum({<status *= {'A','C'}>} sales1)

Re: Error with filters

venkey2847 — Tue, 07 Jun 2016 17:52:07 GMT

HI Sunny,

Thanks for quick reply.

Now it works fine.

Regards

Venkey.

Re: Error with filters

venkey2847 — Wed, 08 Jun 2016 06:25:38 GMT

Hi Sunny,

If you don't mine,Can you give me the functional explanation please, how it works like that.

Thanks in advance

regards

Venkey.

Re: Error with filters

sunny_talwar — Wed, 08 Jun 2016 10:12:50 GMT

Sure, lets take a simpler example

Sum({<Status = {'A', 'C'}>}Sales)

The above expression will not change based on any selection in status field because we have told set analysis to return the sum of sales for only those rows where status = A or status = C.

Sum({<Status *= {'A', 'C'}>}Sales)

The above expression is slightly difference because now the expression will show the intersection between what is selected and what you have mentioned in your set analysis. If you have not selected anything, you will continue to see sum of sales for row where status = A or status = c. But as soon as you make a selection in status, it will return only those status which are common between your selection and what is listed. For example if you select A and B, you will see sum of sales for rows with Status = A. or if you select only B, the expression will become 0 because now there is nothing common between the two.

I hope the above will help you understand how * works.

Best,

Sunny