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.
