topic Re: ignore selection in set analysis in QlikView

ignore selection in set analysis

Mon, 27 Jan 2014 15:58:23 GMT

Hi,

I am using the following statement in set analysis

=Sum({<Status = {'Order'}>}[Order value])

However, I want this expression to ignore any other selection from filter from the status field. For example if any status other than Order is selected, this expression should still show the data for Order status

Can someone please tell me how to fix this

Arif

Re: ignore selection in set analysis

rustyfishbones — Mon, 27 Jan 2014 16:15:19 GMT

What you have should be correct

Re: ignore selection in set analysis

MK_QSL — Mon, 27 Jan 2014 16:42:51 GMT

=Sum({1<Status = {'Order'}>}[Order value])

Re: ignore selection in set analysis

jaimeaguilar — Mon, 27 Jan 2014 17:06:01 GMT

Hi,

your formula will consider only Order Value with status 'Order'. So it doesn't matter if you select other Status, it will be ignored. If you want to ignore other selections apart from Status, you have to put something like this:

=Sum({$<Status = {'Order'}, fieldtoignore1=, fieldtoignoreN=>}[Order value])

regards