topic Re: set analysis in QlikView

set analysis

geogou1973 — Fri, 08 Jan 2016 13:29:31 GMT

Hello.

How can i convert the following expression to set analysis.

if(FORMAT='FRANC' ,SUM(TRIG_QTY),sum(SALES_QTY))

thank you in advance

Re: set analysis

PradeepReddy — Fri, 08 Jan 2016 13:35:28 GMT

Hope, this would not be possible.... You are doing simple aggregations based on condition.

for more things check the basics of Set analysis from Hekp

Re: set analysis

andrespa — Fri, 08 Jan 2016 13:36:21 GMT

Hi Gou,

You can try this:

SUM({<FORMAT = {'FRANC}>}TRIG_QTY) OR SUM({<FORMAT-={'FRANC'}>}SALES_QTY)

Best regards,

Andrés

Re: set analysis

effinty2112 — Fri, 08 Jan 2016 13:37:16 GMT

Hi Geo,

I don't know why you want a set analysis expression but you can try this:

SUM({$<FORMAT={'FRANC'}>}TRIG_QTY) + SUM({$<FORMAT-={'FRANC'}>}SALES_QTY)

If it works for you let us know if speed of calculation is improved.

Re: set analysis

Anonymous — Fri, 08 Jan 2016 13:39:55 GMT

Did you check this?

Set Analysis Beginners Guide v2.0.docx

Learning Set Analysis from Scratch

A Beginners' Introduction to Set Analysis (video)

Re: set analysis

swuehl — Fri, 08 Jan 2016 13:40:27 GMT

Is FORMAT depending on the dimensional value? Or is it depending on the record value?

You may only consider replacing (if you in fact need a recod based evaluation)

SUM( IF(FORMAT='FRANC' , TRIG_QTY,SALES_QTY))

With something like

RANGESUM( SUM( {< FORMAT= {'FRANC'} >} TRIG_QTY), SUM( {<FORMAT -= {'FRANC'} >} SALES_QTY) )

Re: set analysis

Fri, 08 Jan 2016 13:46:43 GMT

Hi ,

Try this ,

It is more useful for u

Set Analysis Wizard for QlikView | qlikblog.at

Re: set analysis

geogou1973 — Fri, 08 Jan 2016 14:18:01 GMT

Hello Andrew.

It is correct and the speed is better than the if formula.

Thank you

Re: set analysis

effinty2112 — Fri, 08 Jan 2016 15:46:53 GMT

Hi Gou,

Glad it worked and great to know that the speed's improved.