topic Re: Set Analysis - Disregard some selections, Accept Others in QlikView

Set Analysis - Disregard some selections, Accept Others

zagzebski — Fri, 26 Apr 2013 16:32:55 GMT

Hope this is simple.

I need to have an expression that disregards all selections EXCEPT for the following

(1) Product = 'Books'

(2) Year Month of Sale = respect the selection(s) that is made

Confused on how I say disregard everything except for #1 and #2

nilesh_gangurde — Fri, 26 Apr 2013 16:39:41 GMT

Hii,

i think you want to ignore the selections. You can ignore the selections by using the following script.

if you want the sum of Amount and that too only for Product = 'Books' then here is the syntax.

Sum({<Product ={"Books"},Field1 =,Field2=>}Amount)

And also the selection made in the Field1 and Field2 are ignored.

-Nilesh

Gysbert_Wassenaar — Fri, 26 Apr 2013 17:10:16 GMT

Something like:

Sum({1<Product ={"Books"},[Year Month]=p([Year Month])>}Amount)

zagzebski — Fri, 26 Apr 2013 17:12:48 GMT

Worked perfect - thanks.