SetAnalysis Query.

[#1]

Hi,

Is this Correct expression ?

I just need to sum of Order qty based on Item Category = UsedCars & Division =50 & Partner_Func =ZS.

How to acheive this. I tried the below expression its not working.

sum({<[Item Category]={UsedCars}, [Division] ={50}, [Partner_Func] ={ZS}>}  [Order qty])

[robert_mika · Accepted solution]

Try this:

sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>}  [Order qty])

[sushil353]

Try this:

sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>}  [Order qty])

HTH

Sushil

[sudeepkm]

Try using ' for string values

sum({<[Item Category]={'UsedCars'}, [Division] ={50}, [Partner_Func] ={'ZS'}>}  [Order qty])

[#5]

hai can any one explain what is setanalysis?

[robert_mika]

A Primer on Set Analysis

Learning Set Analysis from Scratch

Set Analysis: syntaxes, examples

Feeling Qlikngry?

How To /Missing Manual(18 articles)