topic Re: Ignore all selections doesn't work with a condition in QlikView

Ignore all selections doesn't work with a condition

Anonymous — Fri, 29 Sep 2017 07:56:10 GMT

Hello all,

I would like to ignore all the selections done for a graph. I am aware that inserting '1' in front of all the condition it should work as follows:

sum({1<[Project]={'X'},Date = {"=len([Date]) >=0"},Quarter={'Q1'},[Año Presentación]= {$(=Year(Today())) ,$(=Year(Today())-1) },[State =-{'WWW}>} Object)

but in my case it is not working due to this part of the expresion: Date = {"=len([Date]) >=0"} , If I remove this part out of my expression the 1 Set analysis condition works perfectly.

Could you please advice on how I should proceed to ignore all my selections with this part I need Date = {"=len([Date]) >=0"} in the expression?

Thanks in advance!

Re: Ignore all selections doesn't work with a condition

swuehl — Fri, 29 Sep 2017 07:59:05 GMT

Date = {"=len(Only({1}[Date])) >=0"}

Re: Ignore all selections doesn't work with a condition

vinieme12 — Fri, 29 Sep 2017 08:00:04 GMT

create a flag in Load script

if(len([Date]) >=0,1,0) as Flag_DateLen

then replace

sum({1<[Project]={'X'},Flag_DateLen= {1},Quarter={'Q1'},[Año Presentación]= {$(=Year(Today())) ,$(=Year(Today())-1) },[State =-{'WWW}>} Object)

Re: Ignore all selections doesn't work with a condition

Anonymous — Fri, 29 Sep 2017 08:02:28 GMT

Thanks! it works

Re: Ignore all selections doesn't work with a condition

Anonymous — Fri, 29 Sep 2017 08:04:05 GMT

Hello vinieme12

Thanks so much this is another workaround I will take into account!