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

Passing a set of filters in qlikview

bvssudhakar — Tue, 13 Mar 2018 13:04:02 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 .

This is very urgent requirement please help me with your valuable suggestions & answers

Thanks in advance..

Re: Passing a set of filters in qlikview

yujiyamane — Wed, 14 Mar 2018 00:23:27 GMT

Sorry if i misunderstood the requirements, hopefully this is close to what you want. Please find the attached qvw.

Note:

User has to select above filters to see the main chart

To do the slider, there are two variables for min and max.

In the main chart's expression has a condition to show value based on the variables like below.

if((

([rate 1]>= $(vMinRange) and [rate 1]<= $(vMaxRange)) or

([rate 2]>= $(vMinRange) and [rate 2]<= $(vMaxRange)) or

([rate 3]>= $(vMinRange) and [rate 3]<= $(vMaxRange)) )

,sum(volume))

In the main chart, There is below calculation condition in the General tab

=If(

GetSelectedCount(survey)>0 and

GetSelectedCount([prod ctg])>0 and

GetSelectedCount([char])>0 and

GetSelectedCount([char type])>0

,1,0)

In the main chart, Go to error messages in the general tab to add message like below.

Please pass above filters

Re: Passing a set of filters in qlikview

bvssudhakar — Wed, 14 Mar 2018 08:01:24 GMT

Hi Yuji ,

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,

Sudhakar

Re: Passing a set of filters in qlikview

MarcoWedel — Sun, 18 Mar 2018 20:56:07 GMT

Same question already answered here:

Passing a set of filters in qlikview

Re: Passing a set of filters in qlikview

bvssudhakar — Wed, 21 Mar 2018 09:31:52 GMT

Hi Marco ,

I prepared the set filters by using this

https://community.qlik.com/servlet/JiveServlet/download/1453725-318528/CollectFilters_294299.qvw

but i want one small change. instead of the & filters in the variable i want to pass the data which will satisfy all the 5 filters applied.

which means the data which matches all the filters in 5 sets should only display in the result chart / table.

Should i change in the vFilterStates variable expression or should i modify the expression in the chart.

Kindly suggest on how to achieve this.

Thanks

Re: Passing a set of filters in qlikview

MarcoWedel — Wed, 21 Mar 2018 23:18:19 GMT

Hi,

can you describe what result you would expect from which selection sets using this application:

https://community.qlik.com/servlet/JiveServlet/download/1455371-318961/QlikCommunity_Thread_294990.qvw

thanks

regards

Marco

Re: Passing a set of filters in qlikview

bvssudhakar — Thu, 22 Mar 2018 05:10:08 GMT

Hi Marco,

I am unable to open that document, It is showing error

Thank you

Re: Passing a set of filters in qlikview

MarcoWedel — Thu, 22 Mar 2018 22:01:54 GMT

I guess you are using the personal edition.

Did you try to recreate this solution following these steps?:

Re: Error in Calculated Dimension