topic Re: OR & AND Conditions for filters in QlikView

OR & AND Conditions for filters

bvssudhakar — Tue, 20 Mar 2018 09:41:11 GMT

Hi All,

This is my table

survey	prod ctg	char	char type	reqr	crnt	reco
s1	hp	dry grip	comfort	8	4	6
s1	hp	dex	safety	7	6	6
s1	hp	flex	protection	9	7	8
s2	hp	dry grip	comfort	9	5	7
s2	hp	dex	safety	9	7	7
s2	hp	flex	protection	9	8	9
s2	bp	oil factor	comfort	7	4	7
s2	bp	sweat factor	safety	8	6	7
s2	bp	flex	protection	9	8	9

I have created Set of filters by using this thread

Passing a set of filters in qlikview

Now my requirement is: I want apply 'OR' Condition for result set

i want output like this:

I have selected these selections from the categories as set1 filter

prod ctg	char type	char	range
hp	protection	flex	4-8
bp	protection	flex	5-9

So now i want to show the output like this for 'OR' Condition:

HP or BP:

survey	output			reqr	crnt	reco
s1	hp	flex	protection	9	7	8
s2	hp	flex	protection	9	8	9
s2	bp	flex	protection	9	8	9

For AND condition:

HP and BP:

survey	output			reqr	crnt	reco
s2	hp	flex	protection	9	8	9
s2	bp	flex	protection	9	8	9

Can you guys help me out from this please

Thank you in advance

Regards,

B V S Sudhakar

Re: OR & AND Conditions for filters

sunny_talwar — Tue, 20 Mar 2018 11:17:32 GMT

Did you create a sample document which we can look at? It might help to see where you are doing this to help you move forward

Re: OR & AND Conditions for filters

bvssudhakar — Tue, 20 Mar 2018 11:28:50 GMT

HI Sunny,

I cant share the data file due to data confidentiality. i have implemented the same as mentioned in Passing a set of filters in qlikview thread - Rob's answer - file name : CollectFilters_294299..

in the vFilterStates (variable) there is "&" to concatenate the results for filter 1 , filter 2 and other respective filters applied.

as suggested by Rob , here My result set is giving the data for filter 1 and when filter 2 is selected the result for filter 2 is appended with the result of filter set 1 ;..

but what i want is the result set should satisfy both the or all the applied filters set's and then click apply filter and then the data shows up

any ideas on this ?

Thanks,

BVS

Re: OR & AND Conditions for filters

sunny_talwar — Tue, 20 Mar 2018 11:47:42 GMT

There are few questions for you

1) Which one of these is your desired output

2) & is just used to create a string... I am not sure why you want to replace it . Are you may be looking to replace + with *?

=if(len(GetCurrentSelections('','','',1,'Filter1'))>0, 'Filter1*','')

& if(len(GetCurrentSelections('','','',1,'Filter2'))>0, 'Filter2*','')

& if(len(GetCurrentSelections('','','',1,'Filter3'))>0, 'Filter3*','')

& if(len(GetCurrentSelections('','','',1,'Filter4'))>0, 'Filter4*','')

& if(len(GetCurrentSelections('','','',1,'Filter5'))>0, 'Filter5*','')

& '0'

Re: OR & AND Conditions for filters

bvssudhakar — Wed, 21 Mar 2018 09:47:08 GMT

Hi Sunny ,

I prepared the set filters by using this file

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: OR & AND Conditions for filters

sunny_talwar — Wed, 21 Mar 2018 15:26:26 GMT

I understand... did you try the above mentioned changes?

Re: OR & AND Conditions for filters

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

Yes, But it's not working

Re: OR & AND Conditions for filters

bvssudhakar — Thu, 22 Mar 2018 08:48:06 GMT

I want Show second one (AND Condition)

Re: OR & AND Conditions for filters

sunny_talwar — Thu, 22 Mar 2018 10:47:39 GMT

I don't think I am able to understand....

Second one?

Re: OR & AND Conditions for filters

bvssudhakar — Thu, 22 Mar 2018 11:30:30 GMT

Hi sunny,

Here I attached qvw file in that file i want match filter1 and filter 2 values which means like this

If i select for filter 1: Baby Clothes in Category Name, Aino Shoes from Product name, 2012 from Year and

for filter2:Baby Clothes in Category Name, Deuce Shirt from Product name, 2013 from Year

then i want out like this

2422	2/16/2012	Baby Clothes	Aino Shoes	Halle Köln	Bob Park	41
2422	2/16/2012	Baby Clothes	Deuce Shirt	Halle Köln	Bob Park	11
4665	1/21/2013	Baby Clothes	Aino Shoes	La Moda d'il Futuri	Ricardo Gucci	61
4665	1/21/2013	Baby Clothes	Deuce Shirt	La Moda d'il Futuri	Ricardo Gucci	12