topic IF expression with z-analysis in QlikView

IF expression with z-analysis

Fri, 01 Nov 2013 09:08:40 GMT

Hi all,

I'm trying to develop an if expression including z-analysis.

I have three fields in "Club" that I want to conditionally show. When Month=jan, feb, march and april

I want to exclude business case 2 and business case 3. When Month=May, Jun,July and august I want to exclude Business case 1 and business case 2. When Month=Sep, Oct, Nov and December I want to exclude business case 1 and 2.

I have made the below expression that is not working, not sure why.

sum(if(Month='jan',Sum({$<Measure={'Month Development Members'}, Club-={'Business Case 1'} >}))Value)

Re: IF expression with z-analysis

preminqlik — Fri, 01 Nov 2013 12:09:35 GMT

if(Month='Jan' or Month='Feb' or Month='Mar' or Month='Apr' ,Sum({$<Measure={'Month Development Members'}, Club={"*"}-{'Business Case 2','Business Case 3'} >}Value),Sum({$<Measure={'Month Development Members'}, Club={"*"}-{'Business Case 1','Business Case 2'} >}Value))

once see your last statement for months sep ,oct,nov as same as may jun,july .....change according to that data

regards

premhas

Re: IF expression with z-analysis

Gysbert_Wassenaar — Fri, 01 Nov 2013 12:17:10 GMT

Try something like:

sum( {<Month={'jan','feb','mar','apr'},Club-={'BC2','BC3'}> + <Month={'may','jun','jul','aug'},Club-={'BC1','BC2'}> + <Month={'sep','oct','nov','dec'},Club-={'BC1','BC3'}>} Value)

Re: IF expression with z-analysis

preminqlik — Fri, 01 Nov 2013 12:23:26 GMT

hey gysbert ...got something new from you...i'll try this ...thanks man ...