This is my table
|survey||prod ctg||char||char type||reqr||crnt||reco|
I have created Set of filters by using this thread
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|
So now i want to show the output like this for 'OR' Condition:
HP or BP:
For AND condition:
HP and BP:
Can you guys help me out from this please
Thank you in advance
B V S Sudhakar
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 ?
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,'Filter2'))>0, 'Filter2*','')
& if(len(GetCurrentSelections('','','',1,'Filter3'))>0, 'Filter3*','')
& if(len(GetCurrentSelections('','','',1,'Filter4'))>0, 'Filter4*','')
& if(len(GetCurrentSelections('','','',1,'Filter5'))>0, 'Filter5*','')
Hi Sunny ,
I prepared the set filters by using this file
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.
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|