topic Set Analysis (always include all except certain records) in QlikView

Set Analysis (always include all except certain records)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to calculate a value which I do not want to be affected by any selections made by the user. I always want it to calculate based on all the records.

This one below works fine and whatever selection the user makes, the calculated number stays the same:

sum({1}[Amount])/sum({1}[Quantity])

I then inserted a parameter like this:

sum({1}{<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

The expression above calculates correctly the way I want it to. However if a user makes a selection, the value changes, which I do not want. I want it to stay fixed.

Any help? Thanks!

Attached file for reference.

Re: Set Analysis (always include all except certain records)

tresB — Wed, 31 Jan 2018 09:03:22 GMT

You are almost there. Just need to correct brackets. Try:

=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

Re: Set Analysis (always include all except certain records)

kaushiknsolanki — Wed, 31 Jan 2018 09:06:09 GMT

Try this,

=sum({1<[Quantity]={">0"}>}[Amount])/sum({1}[Quantity])

Remove the Extra {} from expression.

Regards,

Kaushik Solanki