Re: Modifying expressions to show "All" as default... - Qlik Community

bvssudhakar · ‎2018-03-19

Hi all ,

I have written the below expression for each filter states. now i want to show all the data when no filter is selected ..

= if(len(GetCurrentSelections('','','',1,'Filter1'))>0, 'Filter1+','')
& if(len(GetCurrentSelections('','','',1,'Filter2'))>0, 'Filter2+','')
& if(len(GetCurrentSelections('','','',1,'Filter3'))>0, 'Filter3+','')
& if(len(GetCurrentSelections('','','',1,'Filter4'))>0, 'Filter4+','')
& if(len(GetCurrentSelections('','','',1,'Filter5'))>0, 'Filter5+','')
& '0'

Kindly help in how to modify this exp to show default "all" values.

i also have a alternate state called "Filtern"

Thanks in advance

swuehl · ‎2018-03-19

Would be good to link to your original thread, so we get the context of this new request.

Passing a set of filters in qlikview

It depends on your designed workflow.

You also have a variable vFilterIndex that you can use:

=

If( vFilterIndex =1, '1',

if(len(GetCurrentSelections('','','',1,'Filter1'))>0, 'Filter1+','')

& if(len(GetCurrentSelections('','','',1,'Filter2'))>0, 'Filter2+','')

& if(len(GetCurrentSelections('','','',1,'Filter3'))>0, 'Filter3+','')

& if(len(GetCurrentSelections('','','',1,'Filter4'))>0, 'Filter4+','')

& if(len(GetCurrentSelections('','','',1,'Filter5'))>0, 'Filter5+','')

& '0'

)

swuehl · ‎2018-03-19

If you don't want to use the variable, you can create a condition based on all the GetCurrentSelections()

If( len(GetCurrentSelections('','','',1,'Filter1'))

+ len(GetCurrentSelections('','','',1,'Filter2'))

+ len(GetCurrentSelections('','','',1,'Filter3'))

+ len(GetCurrentSelections('','','',1,'Filter4'))

+ len(GetCurrentSelections('','','',1,'Filter5'))

>0, '1',