topic Re: Filter data on button click in QlikView

Filter data on button click

Anonymous — Thu, 11 Feb 2016 10:06:23 GMT

Hi All,

I have chart which contains jobname and Execution_status .

I want to show jobnames whose Execution_status ='E' by button Click .

I tried button action and set a variable with expression Only({<Execution_status={'E'}>}Jobname)

But i didn't get desired result .please clarify me where i am wrong .

Thanks

Re: Filter data on button click

sunny_talwar — Thu, 11 Feb 2016 10:08:25 GMT

Is this used a straight table expression? or as a dimension or in a text box? We would need more information to resolve this.

Re: Filter data on button click

sunny_talwar — Thu, 11 Feb 2016 10:14:50 GMT

See if the attached sample make sense

Re: Filter data on button click

Mark_Little — Thu, 11 Feb 2016 10:17:48 GMT

Hi,

I think you where half way there, with the actions choose select in field.

Field = Execution_status

Search string = 'E'

Mark

Re: Filter data on button click

Anonymous — Thu, 11 Feb 2016 10:28:15 GMT

Hi sunny ,

I used the expression in Button under action-> Variable ->Only({<Execution_status={'E'}>}Jobname)

Re: Filter data on button click

sunny_talwar — Thu, 11 Feb 2016 10:31:05 GMT

So you are trying to make a selection on all the job names where Executive_Status is E? Then why not do what Mark said have a select in field in Execution_status where it equals E?

Re: Filter data on button click

Anonymous — Thu, 11 Feb 2016 10:36:08 GMT

Yes ! i have already tried it but it is not working

Re: Filter data on button click

sunny_talwar — Thu, 11 Feb 2016 10:43:58 GMT

Would you be able to share a sample where it isn't working?

Re: Filter data on button click

jonas_rezende — Thu, 11 Feb 2016 11:04:57 GMT

Hi, rgv rand.

Utilize the button according to the image below.

Verify if the data of Execution_Status contain space, case afirmmative use trim(Execution_Status) function in script, after reload.

Hope this helps!

Re: Filter data on button click

sunny_talwar — Thu, 11 Feb 2016 11:11:23 GMT

I think just E (without single quotes and equal sign should do the same thing)

Re: Filter data on button click

Anonymous — Sun, 14 Feb 2016 05:07:26 GMT

Hi jonas.rezende,

Your suggestion is working.

Thanks for your help

Re: Filter data on button click

Anonymous — Sun, 14 Feb 2016 05:11:47 GMT

Hi sunindia

Your suggestion is working even with out quotes.

Could you please clarify how we are getting same results with and with out quotes.Generally quotes are used for search.

Thank you

Re: Filter data on button click

sunny_talwar — Sun, 14 Feb 2016 15:11:02 GMT

Based on my understanding this -> ='E' in a text box would be evaluated to E. So either you use ='E' or E should mean the same thing. There must be a more detailed reason, but I usually look at the search string from the point of view of a text box object.