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.
1) create two alternate state. I have created S1 and S2.
2) create two sets of filters. Left hand side filters are having S1 and right hand side filters are having S2 state.
3) Use straight table having default or inherited state.
4) use expression for Volume as below.
RangeSum(SUM({S1}Volume), SUM({S2}Volume))
Hope this helps.
HI Manish ,
This works but this is not serving the exact purpose of my report.
my main moto is to allow user to select the set of filters using only single list boxes for respective filter column .
and the first set of selections will refresh the data into the table and then the user clears only the filters but not in the table ,, again on the 2nd set of selected filters the result will get appended to the result of set 1 in the tabel.
main catch is in displaying the selected filters as set 1 and set 2..
please shower thoughts on the same if you have any.
Thanks
Qlik is not storing your selected values in different set of filters.
I think this is difficult to achieve.
So I have provided solution using alternate state which is not 100% the same.
You can, though, wait for Qlik Expert to give you answer on this, as I don't have any answer apart from this.
Thanks for your support Manish.
hope any Qlikview Expert will revert and i ll be able to achieve this.
Thanks again.
stalwar1, please have your thought here !
Checking
mrkachhiaimp not sure if this would work for OP or not, but the other option is using variables
Hi Sunny,
Thanks for this answer but unfortunately this doesn't solve our purpose ,
our requirement is as given below:
As you can see in the above image the user has selected 3 filters , which is to be treated as filter set 1 .
the user needs to select 5 more sets of filters and all of the filters should be applied into the result set.
for example :
set 2 filters can be as given below
Characteristic = Dexterity
Category = Category 2
product Type = Product 2
So considered this selected filters the result set should display 2 entries in the table which is for the Set 1 AND Set 2 Filters applied .
so my final result set would have both the entries for cut and Dexterity after the SET 1 and SET 2 Filters are applied .
Kindly share the thoughts on how to acheive this.
Thanks in advance,
We have put forward two techniques (alternate state and variables) which is doing exactly what you want.... but I am not sure why it isn't solving your purpose..... what exactly is the concern with alternate state or variable approach? I mean from what I see... they are doing exactly what you have mentioned... but you somehow seem to disagree? or are you concerned about something else?
Hi Sunny ,
Yes , the thing bothering me is i don't want to use 2 list boxes to select different entries / filters. i am trying to give the user to select in single list box.
Thanks