Set analysis - one field non sensitive

[maxime66]

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.

[PrashantSangle]

Hi,

If you want to nullify selection then add

state=

in your set analysis.

Kind Regards

[avinashelite]

try like this

count({<State=> }policies)

[maxime66]

it doesn't work :

like this ?

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

[MK_QSL]

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

[avinashelite]

like this

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

or

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

[PrashantSangle · Accepted solution]

Hi,

did not get your logic..

try like

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

[jagan]

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.

[avinashelite]

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

[maxime66]

Thanks to all of you,

this one works perfect

++