Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I guess chandana.gowdar wants to select a set of selection and then remove them and then make another set of selections. If the additional selections can be on top of the first set of selection... then I guess you are right. But if the selections are removed, how will this still work?
Hi Rob ,
I am sorry to say that you have misunderstood the requirement.
the actual requirement is that i have 5 filters(list boxes with multiple selection enabled)
i want to select 1 or multiple selections in each list box, which will be treated as set 1 ,
for example SET 1 Filter =
Filter 1 = A and B
Filter 2 = India
Filter 3 = Earth
Filter 4 = Water
Filter 5 = 5000
so here SET 1 = (Filter 1 + Filter 2+Filter 3+Filter 4+Filter 5)
once the SET 1 is selected the data related to these filters will be displayed in the result set table.
Next step : clear ONLY THE FILTERS AND THE RESULT SET TABLE REMAINS SAME WITH THE RESULT SET OF SET 1
Like this User should be allowed to select 5 SETS .
WHEN SELECTED SET 2 , THE RESULT SET SHOULD BE APPENDED WITH THE SET2 WITH THE ENTRIES WHICH WERE PRESENT FOR SET2.
SORRY IF I HAVE CONFUSED YOU TOO MUCH, BUT ACTUALLY THIS IS THE REQUIREMENT.
THANKS
Rob, i think a single set (of list boxes) wouldn't allow
Cat1 and factor1
OR
Cat2 and factor2
You can conditionally hide / show the list boxes using the feature on layout tab:
I could see an edge case where you may need to separate selections. But when the OP said they were new to QV, I thought they may be missing that a simple solution would be to have the use make multiple selections. I see requirements like this occasionally from new customers where they try to make QV operate like a workflow/app they are used to. It's not always a good idea and usually resolved with simple QV by taking a step back and understanding the business requirement.
All that said, if someone wanted to build up a set of discrete filters and union the results, I would think the solution would be a modified version of something like this:
Qlikview Cookbook: Defer Selections Until Apply http://qlikviewcookbook.com/recipes/download-info/defer-selections-until-apply/
where a button copies the selections into incrementing alternate state slots. When all slots are filled the chart displays. Another "reset" button resets the alternate state index.
-Rob
Hello Sunny,
I tried with dynamically created previous selection set identifiers like {$1+$3+$5} but failed (I guess due to trigger effects when storing the current set state in a variable).
Maybe this might be a solution nevertheless (when done properly).
regards
Marco
Hi Rob ,
Thanks for providing the link , i tried implementing that and it has partially helped me to get closer to the requirement.
There is one catch here , before clicking on the "apply filter " button i want to pass sets of filters.
here a set means single or multiple selection of the filters . here i need to figure out how to capture or convey qlikview to consider the selections as set 1 and then create a button to say "select 2nd set of filters". then use your "apply filter" button.
currently this is the situation, if you have any ideas on how to achieve this , please suggest.
Many Thanks.
Here is a quick sample QVW that demonstrates an approach using alternate states with a single set of list boxes.
You can set basically two sets, but the demo can be easily expanded to as many as you like.
Hi,
maybe another solution could be:
=vSelSets&If(Len(GetCurrentSelections()),If(Len(vSelSets),'+')&'1<['&GetCurrentSelections(Chr(39)&'}, [',']={''',Chr(39)&','&Chr(39))&Chr(39)&'}>')
hope this helps
regards
Marco
Hi,
another solution might be to apply this approach on a key field:
hope this helps
regards
Marco