topic Re: Set analysis - one field non sensitive in QlikView

Set analysis - one field non sensitive

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

Hi Qlikers,

i would like to count policies at specific dates.

For instance (Qvw attached) i would like to count the number of policies at 31/12/2015 ( = 3)

My constraint is that i have to filter the "State" field on "Active" in the all sheet , and my number becomes ( = 2)

i just want to neutralize this field in my set Analysis (and just this one)

Thx four your help.

Re: Set analysis - one field non sensitive

PrashantSangle — Tue, 26 Apr 2016 13:04:17 GMT

Hi,

If you want to nullify selection then add

state=

in your set analysis.

Kind Regards

Re: Set analysis - one field non sensitive

avinashelite — Tue, 26 Apr 2016 13:04:40 GMT

try like this

count({<State=> }policies)

Re: Set analysis - one field non sensitive

maxime66 — Tue, 26 Apr 2016 13:07:10 GMT

it doesn't work :

like this ?

=count( {<State=>*<start={"$(= '<=' & '$(date_stock)' )"}>*<end={"$(= '>=' & '$(date_stock)' )"}>} distinct policies)

Re: Set analysis - one field non sensitive

MK_QSL — Tue, 26 Apr 2016 13:09:24 GMT

If(Dimensionality()=0,COUNT({<state>}TOTAL policies), COUNT(policies))

Re: Set analysis - one field non sensitive

avinashelite — Tue, 26 Apr 2016 13:09:45 GMT

like this

count( {<start={"$(= '<=' & '$(date_stock)' )"}, State=>*<end={"$(= '>=' & '$(date_stock)' )"}>} distinct policies)

count( {<start={"$(= '<=' & '$(date_stock)' )"}, State=>*<end={"$(= '>=' & '$(date_stock)' )"},State=>} distinct policies)

Re: Set analysis - one field non sensitive

PrashantSangle — Tue, 26 Apr 2016 13:11:22 GMT

Hi,

did not get your logic..

try like

count( {<start={"$(= '<=' & '$(date_stock)' )"},state=>*<end={"$(= '>=' & '$(date_stock)' )"},state=>} distinct policies)

Re: Set analysis - one field non sensitive

jagan — Tue, 26 Apr 2016 13:12:16 GMT

Hi,

Try this as expressions

count =count({<state=>}policies)

Count_stock_at_date=count( {<state=, start={"$(= '<=' & '$(date_stock)' )"}>*<state=, end={"$(= '>=' & '$(date_stock)' )"}>} distinct policies)

This (state=) will ignore the selections in that field.

Regards,

Jagan.

Re: Set analysis - one field non sensitive

avinashelite — Tue, 26 Apr 2016 13:13:49 GMT

Why your using the * (intersection)?? is that the requirement ??

if not the case you could try like this

count( {<State=,start={"$(= '<=' & '$(date_stock)' )"}, end={"$(= '>=' & '$(date_stock)' )"}>} distinct policies)

make sure the dates are all in the correct format

Re: Set analysis - one field non sensitive

maxime66 — Tue, 26 Apr 2016 13:15:02 GMT

Thanks to all of you,

this one works perfect