Difference between Match function result and set modifier ewault

[HariIyer]

A little help please !!

 I am trying to understand  the difference in these two expressions. They both return the same result set.

1) =Count({$<[Item.Parent Full Name]={'Equipment Inventory:New Equipment'}>}[Transactions.Quantity With Sign])

 and 

2) =count(if(match([Item.Parent Full Name],'Equipment Inventory:New Equipment')>0,[Transactions.Quantity With Sign]))

 Best Regards

 Hari

[Vegar]

You can expect the same output from the two expressions, they are calculating the same thing but with two different approaches.

The first expression is an set analysis. I would categorize your second expression as a conditional aggregation expression. In most cases the first (set analysis) expression would be the most effective calculation and preferred over the second.

You can read about the difference between the two approaches in Henric Cronströms old blog post Conditional Aggregations - Qlik Community - 1473362 from 2014.

/Vegar

[HariIyer]

Thanks you got the quick reply
Best regards