topic Re: Passing a set of filters in qlikview in QlikView

Passing a set of filters in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Passing a set of filters in qlikview

MK_QSL — Mon, 12 Mar 2018 08:16:53 GMT

You have given long description, but can you also post the final answer you are looking for?

i.e. Apply filter and what could be the output ?

Re: Passing a set of filters in qlikview

techvarun — Mon, 12 Mar 2018 08:21:48 GMT

You mean the table should appear only after selecting all the five filters?

Re: Passing a set of filters in qlikview

Anonymous — Mon, 12 Mar 2018 08:56:29 GMT

Hi Varun,

yes the filter should appear only after the 5 filters are selected and each filter is a set of filters.

i.e Set 1 is prod ctg = ctg 1 , char = factor 1 and char type = type 1

after selecting the above set of filters the table should be displayed.

then the filters are cleared or the selections of filters are cleared to allow the user to select the second set of filters , but the result in the table should still be available

so when user selects the second set of filters

Set 2 is prod ctg = ctg 2 , char = factor 4 and char type = type 1

and say apply filter

The result table should have both the results of SET 1 and SET 2

---------------------------------------------------

kindly shower your thoughts on the same.

it would be helpful if you suggest anything possible on this scenario.

Thanks

Re: Passing a set of filters in qlikview

Anonymous — Mon, 12 Mar 2018 08:59:08 GMT

Hi Manish ,

the out would be expected in a table calculating the volume of the filters selected.

for example :

Set 1 filter is prod ctg = ctg 1 , char = factor 1 and char type = type 1

after selecting the above set of filters the table should be displayed.

then the filters are cleared or the selections of filters are cleared to allow the user to select the second set of filters , but the result in the table should still be available

so when user selects the second set of filters

Set 2 filter is prod ctg = ctg 2 , char = factor 4 and char type = type 1

and say apply filter

The result table should have both the results of SET 1 and SET 2

please help on how to achieve this.

Thanks

Re: Passing a set of filters in qlikview

MK_QSL — Mon, 12 Mar 2018 09:04:04 GMT

Provide output in excel file, if possible.

Re: Passing a set of filters in qlikview

Anonymous — Mon, 12 Mar 2018 09:18:05 GMT

Hi Manish,

Find the below data and the expected :

Data available:
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
set 1 filters : prod ctg = catg 1 , char = factor 1 and char type = type 1
set 2 filters : prod ctg = catg 1 , char = factor 2 and char type = type 2
Output required when Set 1 is applied :
survey	prod ctg	char	char type	rate 1	rate 2	rate 3	volume	This table results when the set 1 filters are applied
s1	catg 1	factor1	type 1	8	4	6	100
s2	catg 1	factor1	type 1	9	5	7	400 500
Output required when Set 1 and Set 2 is applied :
survey	prod ctg	char	char type	rate 1	rate 2	rate 3	volume	This table results when the set 2 filters are applied with the result of Set 1 Filters.
s1	catg 1	factor1	type 1	8	4	6	100
s2	catg 1	factor1	type 1	9	5	7	400
s1	catg 1	factor2	type2	7	6	6	200
s2	catg 1	factor2	type2	9	7	7	500 1200

Thanks

Re: Passing a set of filters in qlikview

Anonymous — Tue, 13 Mar 2018 10:44:16 GMT

Hi Manish ,

Any Ideas on the mentioned post??

Re: Passing a set of filters in qlikview

MK_QSL — Tue, 13 Mar 2018 13:30:58 GMT

You can achieve the same using alternate state.

Something like enclosed..

Re: Passing a set of filters in qlikview

Anonymous — Tue, 13 Mar 2018 14:04:05 GMT

Hi Manish ,

Thanks for the suggestion , but i am not able to figure out what is enclosed alternate state.

i tried creating state 1 and state 2 for 2 listboxes.. seems like the table should also be assigned some state for the filter to be effected.

please help on how to acheive this.

I also have 5 filters in my case and i cannot be giving the same filters multiple times. so i guess your suggested method may completely satisfy my criteria.

Kindly suggest on the same.

Many Thanks in Advance.

Re: Passing a set of filters in qlikview

MK_QSL — Tue, 13 Mar 2018 14:09:08 GMT

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.

Re: Passing a set of filters in qlikview

Anonymous — Tue, 13 Mar 2018 14:34:01 GMT

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

Re: Passing a set of filters in qlikview

MK_QSL — Tue, 13 Mar 2018 14:39:10 GMT

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.

Re: Passing a set of filters in qlikview

Anonymous — Tue, 13 Mar 2018 14:42:29 GMT

Thanks for your support Manish.

hope any Qlikview Expert will revert and i ll be able to achieve this.

Thanks again.

Re: Passing a set of filters in qlikview

MK_QSL — Tue, 13 Mar 2018 14:47:24 GMT

stalwar1‌, please have your thought here !

Re: Passing a set of filters in qlikview

sunny_talwar — Tue, 13 Mar 2018 14:51:50 GMT

Checking

Re: Passing a set of filters in qlikview

sunny_talwar — Tue, 13 Mar 2018 15:04:13 GMT

mrkachhiaimp‌ not sure if this would work for OP or not, but the other option is using variables

Re: Passing a set of filters in qlikview

Anonymous — Wed, 14 Mar 2018 10:54:24 GMT

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,

Re: Passing a set of filters in qlikview

sunny_talwar — Wed, 14 Mar 2018 11:03:49 GMT

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?

Re: Passing a set of filters in qlikview

Anonymous — Wed, 14 Mar 2018 11:17:12 GMT

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