Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bvssudhakar
Contributor II

Passing a set of filters in qlikview

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. 1.survey
  2. 2.prod ctg
  3. 3.char
  4. 4. char type
  5. 5. range slicer(0-10)

output table displays the following columns

  1. 1.survey
  2. 2.prod ctg
  3. 3.char
  4. 4.char type
  5. 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..


7 Replies
yujiyamane
Contributor II

Re: Passing a set of filters in qlikview

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

bvssudhakar
Contributor II

Re: Passing a set of filters in qlikview

Hi Yuji ,

Thanks for this answer but unfortunately this doesn't solve our purpose ,

our requirement is as given below:

qv screenshot.JPG

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 .

Capture.JPG

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

Same question already answered here:

Passing a set of filters in qlikview

bvssudhakar
Contributor II

Re: Passing a set of filters in qlikview

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

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.q...

thanks

regards

Marco

bvssudhakar
Contributor II

Re: Passing a set of filters in qlikview

Hi Marco,

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

Thank you

Re: Passing a set of filters in qlikview

I guess you are using the personal edition.

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

Re: Error in Calculated Dimension