topic Re: Action on Textbox in QlikView

Action on Textbox

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

Hi,

I just want to ask. I have this Textbox with name "Admin" I want to add an action that when I clicked the "Admin" Text, I can filter a certain field. Do you know how I can do that? I've checked "Select Field" and "Toggle Select" action but I doesn't work. I hope you can help me out here.

Thanks in advance!

Re: Action on Textbox

ecolomer — Tue, 15 Aug 2017 08:22:23 GMT

Yes you can put ACTIONS on Text Box.

In the label ACTIONS, select the actions required.

If you need more help, upload a little example file

Re: Action on Textbox

ksomosera10 — Tue, 15 Aug 2017 08:24:22 GMT

That is my question....

How can I put action to filter a certain field...

For example:

If I click the "Admin" text, it will filter out all admin on Field Status.

Re: Action on Textbox

marcus_malinow — Tue, 15 Aug 2017 08:39:07 GMT

Hi Kevin,

are you looking to select 'Admin' in your 'Status' field. If so, add a 'Select in Field' action to your text object. Set the field to 'Status' (no quotes!), and Search String to 'Admin' (again, no quotes!).

If you are looking to exclude 'Admin', set your search string to '(* ^ Admin)' (without quotes)

Marcus

Re: Action on Textbox

ksomosera10 — Tue, 15 Aug 2017 08:46:29 GMT

Thanks Marcus!

Yes, it works on the field but it doesn't reflect on my other graphs...

What I want was also to filter out other graphs using the action coming from the TextBox.

Like I said, when I clicked on "Admin" the field status will be admin and also other graphs that uses status fields.

Thanks!

Re: Action on Textbox

ecolomer — Tue, 15 Aug 2017 08:46:32 GMT

Sorry because my QV is in Spanish

Re: Action on Textbox

mdmukramali — Tue, 15 Aug 2017 08:49:00 GMT

Dear Kevin,

you can set actions on text object :

Re: Action on Textbox

ksomosera10 — Tue, 15 Aug 2017 08:49:51 GMT

Thanks Enrique.

Yes I did that. But is hasn't moved the graphs and other visuals using status

Re: Action on Textbox

marcus_malinow — Tue, 15 Aug 2017 08:51:11 GMT

Ok, this is indicative of an issue with your expressions, or perhaps your data model.

Do the expressions in your charts have any set analysis relating to the Status field?

Is the table containing the Status field linked to the tables that are being used to derive your charts?

Marcus

Re: Action on Textbox

marcus_malinow — Tue, 15 Aug 2017 08:52:21 GMT

If you can, I'd suggest uploading a copy of your .qvw

https://community.qlik.com/docs/DOC-1290

Re: Action on Textbox

ecolomer — Tue, 15 Aug 2017 08:53:21 GMT

When you click text box with the select values in field selected, see field selecteds in order to see the action is right