Dynamic filter in Qlikview

[arvind_patil]

Hi  Experts,

Someone please explain me whats wrong in my attached Qvw.

I am Trying to achieve:

I have  input filed and its value in input box  filter must be apply on all data as like below thread.

Like as https://community.qlik.com/message/1322981#1322981

Thanks,

Arvind Patil

[arvind_patil]

Hi Anil,

I require to basis on specific field rather than whole data. I mentioned their field name as well as Its values.

Thanks,

Arvind Patil

[Kushal_Chawda · Accepted solution]

create two variables and add them in inputbox

1) vFieldName

Input field name which you want to filter

Note: Field name is case sensitive, so value entered must be exactly match with original field name

2) vValue

enter field values which you want to filter

Note: Values should be comma separated and also case sensitive

Create button and add a action Select in Field

Field

=vFieldName

Value

='('& Replace(vValues,',','|')&')'

[arvind_patil]

Hi Khushal,

Its working what I expected , But suppose   I want to implement using single input box for Fieldname And its Values then how?.

Thanks,

Arvind Patil

[Kushal_Chawda]

There is always a way to do that but I prefer organized way to achieve this. If you use the single inputbox then user may get confused with what and how to enter. You need to follow some pattern for which you need extra coding. But if you still want using one inputbox, can you tell me how you are going to enter both Fieldnames and values?

[arvind_patil]

Hi Khushal,

If  I want filter from specific filed then i will enter like below

City

Pune

Karad

So it will look into City filed .

Thanks,

Arvind Patil

[Kushal_Chawda]

Create variable in which you can enter the Field Name with value

vFieldValue

Enter the Field name and Value in Comma separated format -> FieldName,FieldValue1, FieldValue2

eg. City,Mumbai,Pune

Note:

1) All filed Name and field values are case sensitive

Create a two new variables which holds the Field Value & Field Name respectively like below

1) vField

=SubField(vFieldValue,',',1)

2) vValue

=mid(vFieldValue,Index(vFieldValue,',')+1)

Create button and add a action Select in Field

Field

=vFieldValue

Value

='('& Replace(vValue,',','|')&')'

[arvind_patil]

  Happy to saw your response ,Its working ,

Thanks,

Arvind Patil