topic Re: Comparing columns in set analysis in App Development

Comparing columns in set analysis

ali_hijazi — Sun, 24 Jan 2021 15:00:17 GMT

Hello Qlik_ers
I was reviewing the set analysis in the help page of Qlik and I found the following:

sum({$<OrderDate = DeliveryDate>} Sales)

Returns the sales for the current selection where OrderDate = DeliveryDate.

and you can find this under the following link:
https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

the editor give ok on the syntax
I always know that I need a key column and write instead sum({<key_column={"=OrderDate=DeliveryDate"}>}Sales)

so I tried what is written in the help link in my dashboard I have but this doesn't work at all and always returns zero

Kindly advise

Re: Comparing columns in set analysis

Anil_Babu_Samineni — Sun, 24 Jan 2021 16:45:35 GMT

It is not mandatory to have Key column until unless your data literacy wrong in model. You can simplify this way

sum(If(OrderDate = DeliveryDate, Sales))

Re: Comparing columns in set analysis

Ksrinivasan — Sun, 24 Jan 2021 19:22:05 GMT

hi,

yes for me also result become Zero

ksrinivasan

Re: Comparing columns in set analysis

ali_hijazi — Mon, 25 Jan 2021 10:47:10 GMT

using if else in expressions result in very slow response
I never used if else (but rarely)

Re: Comparing columns in set analysis

ali_hijazi — Mon, 25 Jan 2021 10:47:32 GMT

so how come they put something that doesn't work?!

Re: Comparing columns in set analysis

marcus_sommer — Mon, 25 Jan 2021 13:59:25 GMT

I think it's a mistake within the help maybe a copy & paste error from an alpha-release of the set analysis (earlier as QV 8.5) as they developed this feature. I could imagine that those syntax was functionable at this time and they decided to remove it from the final product because it could be never a pure set analysis. This means both mentioned approaches:

{$<OrderDate = DeliveryDate>} and {"=OrderDate=DeliveryDate"}

aren't a real set analysis else an if-loop in the syntax of a set analysis and mainly the same like:

if(OrderDate=DeliveryDate, sum(Anything))

- Marcus