Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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