Solved: Dynamic filter in Qlikview - Qlik Community

arvind_patil · ‎2017-08-22

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

Kushal_Chawda · ‎2017-08-22

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

View solution in original post

Anil_Babu_Samineni · ‎2017-08-22

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Kushal_Chawda · ‎2017-08-22

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

arvind_patil · ‎2017-08-22

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

arvind_patil · ‎2017-08-22

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

Re: Search Option, Dynamic filtering?

Thanks,

Arvind Patil

Kushal_Chawda · ‎2017-08-22

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

arvind_patil · ‎2017-08-22

Yes Exactly! I am looking for bro.,.

Thanks,

Arvind Patil

Anil_Babu_Samineni · ‎2017-08-22

PFA

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

arvind_patil · ‎2017-08-22

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

Anil_Babu_Samineni · ‎2017-08-22

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Dynamic filter in Qlikview

Related Topics