set analysis

[geogou1973]

Hello.

How can i convert the following expression to set analysis.

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

thank you in advance

[PradeepReddy]

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

[andrespa]

Hi Gou,

You can try this:

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

Best regards,

Andrés

[effinty2112 · Accepted solution]

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.

[Anonymous]

Did you check this?

Set Analysis Beginners Guide v2.0.docx

Learning Set Analysis from Scratch

A Beginners' Introduction to Set Analysis (video)

[swuehl]

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) )

[#7]

Hi ,

Try this ,

It is more useful for u

Set Analysis Wizard for QlikView | qlikblog.at

[geogou1973]

Hello Andrew.

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

Thank you

[effinty2112]

Hi Gou,

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