passing a set of filters(multiple filters as one set) 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 use 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.