topic Re: set analysis ignore selection in App Development

set analysis ignore selection

lvdbrink — Fri, 31 Jul 2015 09:50:59 GMT

Hello all,

I am currently converting a Qlikview document to a qlik sense application. The Qlikview document uses a lot of set analysis in it;s measures. Most of these can be copied over to sense and perform as expected. However, I have one expression that does not seem to work in Sense:

AVG({$<Vendor=, Product=>Sales}

This expression should calculate the average of sales, ignoring Vendor and Product selections. However, Sense evaluates this expression exactly similar to:

AVG(Sales)

for all possible selections. I know my expressions are correctly formulated, since they work in and are directly copied from an existing Qlikview document. Is this a known difference in functionality, or is this a bug?

Also, I'd like to hear if you have any suggestions to rewrite the expression in a way that Qlik Sense evaluates it correctly.

Thanks in advance!

Re: set analysis ignore selection

swuehl — Sat, 01 Aug 2015 10:28:04 GMT

Lennaert van den Brink wrote:

I know my expressions are correctly formulated, since they work in and are directly copied from an existing Qlikview document. Is this a known difference in functionality, or is this a bug?

I don't think the expression will work even in QV, it shows incorrect syntax

AVG({$<Vendor=, Product=>Sales}

should be written as

AVG({$<Vendor=, Product=>} Sales)

Re: set analysis ignore selection

lvdbrink — Sat, 01 Aug 2015 15:39:07 GMT

That is just a typo in the post, sharp eyes, but sadly not the issue here.