topic Re: Set analysis function using variable to ignore certain fields in QlikView

Set analysis function using variable to ignore certain fields

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

Hi everyone,

I have text box using variable : 'vOrder_Volume' , I have multiple filters in my dashboard Like Country, zone, branch, Code etc. But I want to keep this affected by only Branch and below level selection and ignore all above level (Zone, Country) selection , How to make set analysis expression or Is there any other way to achieve that ?Can anyone please help me with that?

Thanks

Re: Set analysis function using variable to ignore certain fields

Saravanan_Desingh — Fri, 22 May 2020 00:31:23 GMT

May be try like this..

Count({<Country, zone, Code>}FieldA)

This will ignore selections on Country, zone and Code.

Re: Set analysis function using variable to ignore certain fields

whiteymcaces — Fri, 22 May 2020 08:04:01 GMT

What you are trying to achieve is not entirely clear, however, if you want to use a user input variable to control what selections are ignored in an expression, then you could try something like:

Sum({<$(vIgnoreSelections)>} Amount)

Where vIgnoreSelections has been set to equal Zone, Country (or what other selections you want to be ignored)

Let vIgnoreSelections = 'Zone, Country'; //in the script

You can add vIgnoreSelection to an Input Box object so users can type fields to ignore, but they must be careful to type it exactly correct.