Set Analysis Row level

[qlik4asif]

Hello Guys,

Please help me in fixing the below set expression.

Min({<Daywise_Orders_Cum={">=$(=Sum(Available_Stock))"}>}Belege_Date)

The above expression is used in straight table where it is calculating all the stock and comparing with daywise orders,

but i have Material as dimension in table, and i want to check the stock of each parts with their demands,

which means the above set expression should calculate at row level.

please help me out

[Taoufiq_Zarra]

@qlik4asif  can you share a sample data and the expected output ?

[qlik4asif]

[marcus_sommer]

You could try it in this way:

Min({<Daywise_Orders_Cum={"=Daywise_Orders_Cum>=Sum(Available_Stock)"}>}Belege_Date)

whereby it's in this way no real set analysis anymore else it behaved now like an if-loop.

- Marcus

[qlik4asif]

@marcus_sommer 

Thanks alot.

Solution worked

So i believe for Row wise calculation in front end we need to write this kind of expression.

Is it true, normal set expression( which i wrote above ) will calculate only once per chart?

Once again thanks alot

[marcus_sommer]

Normal set expressions work like a selection globally on the dataset and values are included or excluded without any furher dimensionality.

- Marcus