Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
)
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',
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'
)