topic How to select in QlikView

How to select

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

Hi,

i have a formula that basically assign a flag (1) or (0) based on the fact that a customer is selling more than 10K or less than 10K. (as formula below).

There's a way to select only customers having Flag 1 or 0 based on the formula below?

Thank you

=if(

(if(vExcludeInstrumentSales,sum({<Area-={'Area-not-available'}>}ExtendedUSD),Sum({<Area-={'Area-not-available'},Item_Category={$(vNoInstruments)}>}ExtendedUSD))/1000)>10 and

(if(vExcludeInstrumentSales,sum({<Year = {"$(=Max(Year)-1)"},Area-={'Area-not-available'}>}ExtendedUSD),Sum({<Year = {"$(=Ma(Year)-1)"},Area-={'Area-not-available'},Item_Category={$(vNoInstruments)}>}ExtendedUSD))/1000)=0,

1,0)x

Re: How to select

YoussefBelloum — Thu, 09 Nov 2017 10:27:36 GMT

Hi,

basically you can do it with the IF: if( match(Flag,1,0), YOUR EXPRESSION...)

or add it in the set analysis ==> Flag={1,0}

Re: How to select

rubenmarin — Thu, 09 Nov 2017 11:27:04 GMT

Hi Antonio,

Best approach will be to create a field in script where users can select.

To use without creating a field you can use aggr() to assign a value for each customer:

Aggr(

if(Flag=1,'> 10K', '< 10K')

, Customer)