Passing a set of filters in qlikview

[Anonymous]

Hi all ,

I have this below given requirement to display as a table in the qlikview document with the set of filters passed for filtering the data.

survey	prod ctg	char	char type	rate 1	rate 2	rate 3	volume
s1	catg 1	factor1	type 1	8	4	6	100
s1	catg 1	factor2	type2	7	6	6	200
s1	catg 1	factor3	type 3	9	7	8	300
s2	catg 1	factor1	type 1	9	5	7	400
s2	catg 1	factor2	type2	9	7	7	500
s2	catg 1	factor3	type 3	9	8	9	600
s2	catg 2	factor4	type 1	7	4	7	700
s2	catg 2	factor2	type2	8	6	7	800
s2	catg 2	factor3	type 3	9	8	9	900

the filters given on the report are :

1.survey

2.prod ctg

3.char

4. char type

5. range slicer(0-10)

output table displays the following columns

1.survey

2.prod ctg

3.char

4.char type

5.volume

the requirement is that the user must be allowed to pass 6 sets of filter.

set of filters include one from the available 5 filters(survey,prod ctg,char,char type,range slicer value)

OR condition needs to be applied when the filter values are passed.

for example: set1 filters OR set2 filters (output will now diplay the data for both the filters selected in set 1 and set 2 )

as i am new to qlikview , i have no idea how to solve this..

can this be handled by setanalysis ? if not then how can this be handled.

Kinldy help with any supportive expressions.

will be greatfull for any kind of help on this post .

thanks.

[Anonymous]

Hi Stefan ,

in the below given expression ,

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

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

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

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

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

     =0, '$',

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')

the variable set is accepting all values when no filter is passed , how can we instruct the filter set to be set to none when no filter is set and to filter only when the filters are passed ,

Kindly suggest on the same..

Thanks