topic Re: Difference between Match function result and set modifier ewault in QlikView

Difference between Match function result and set modifier ewault

HariIyer — Tue, 17 Aug 2021 15:25:34 GMT

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

Re: Difference between Match function result and set modifier ewault

Vegar — Tue, 17 Aug 2021 16:24:35 GMT

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

Re: Difference between Match function result and set modifier ewault

HariIyer — Tue, 17 Aug 2021 17:21:11 GMT

Thanks you got the quick reply
Best regards