topic Re: Dynamic filter in Qlikview in QlikView

Dynamic filter in Qlikview

arvind_patil — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dynamic filter in Qlikview

Anil_Babu_Samineni — Tue, 22 Aug 2017 10:37:31 GMT

If you are enter City as pune then how you want to see in report?

Re: Dynamic filter in Qlikview

Kushal_Chawda — Tue, 22 Aug 2017 10:47:15 GMT

Can you tell us what exactly you are trying to achieve or what is exact requirement?

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 10:48:40 GMT

Hi Anil,

Suppose If I Enter:

City

Pune

And Apply Then All Pune data will be filter other than this cities are gray out.

Thanks,

Arvind Patil

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 10:50:37 GMT

If you look into attached Thread I am Trying to achieve same to same.

Re: Search Option, Dynamic filtering?

Thanks,

Arvind Patil

Re: Dynamic filter in Qlikview

Kushal_Chawda — Tue, 22 Aug 2017 11:03:48 GMT

If user enters the city names in inputbox and click on button, that values should get selected?

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 11:07:51 GMT

Yes Exactly! I am looking for bro.,.

Thanks,

Arvind Patil

Re: Dynamic filter in Qlikview

Anil_Babu_Samineni — Tue, 22 Aug 2017 11:13:31 GMT

PFA

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 11:25:52 GMT

Hi Anil,

thanks for Your prompt response but I am looking for dynamic filter. Means May I filter on City or else ID its depend On Me. I just pass field and its Values

Thanks,

Arvind Patil

Re: Dynamic filter in Qlikview

Anil_Babu_Samineni — Tue, 22 Aug 2017 11:28:20 GMT

Why you need that, Unless we have Search object. Your users don't like to use Search object rather this work.

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 11:34:15 GMT

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

Re: Dynamic filter in Qlikview

Kushal_Chawda — Tue, 22 Aug 2017 11:55:15 GMT

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,',','|')&')'

Re: Dynamic filter in Qlikview

arvind_patil — Tue, 22 Aug 2017 12:07:42 GMT

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

Re: Dynamic filter in Qlikview

Kushal_Chawda — Tue, 22 Aug 2017 12:15:08 GMT

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?

Re: Dynamic filter in Qlikview

arvind_patil — Wed, 23 Aug 2017 03:45:26 GMT

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

Re: Dynamic filter in Qlikview

Kushal_Chawda — Wed, 23 Aug 2017 09:34:32 GMT

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,',','|')&')'

Re: Dynamic filter in Qlikview

arvind_patil — Wed, 23 Aug 2017 09:46:06 GMT

Happy to saw your response ,Its working ,

Thanks,

Arvind Patil