Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Which Action + setup for creating a Button

Good day,

I have the following issue. I made a chart, containing the script below.

TRACE ### Verzoeken Verplichting Type 204;

SQL SELECT FreeguidField_01 as Verplichting_ID_Verzoek,

FreeBoolField_01 AS Verplichting_204,

Case when FreeBoolField_01 = '1' Then 'Lopende Verplichting Afgeboekt' ELSE 'Openstaande Verplichtingen' END as Verplichting_PV,

RelatedRequestID as Verplichting_Aanvraag_ID

FROM Synergy.dbo.Absences

Where type in (204)

;

It works perfect and I can select 'Lopende Verplichting Afgeboekt' or 'Openstaande Verplichtingen'

Instead of the selection box, I would like to create a button with only the selection of 'Openstaande Verplichtingen'

I tried several Actions in the setup of a new button, but somehow none works.

Can someone help me with this?

Thanks in advance!

Regards,

Kees-Jan

1 Solution

Accepted Solutions
Employee
Employee

Re: Which Action + setup for creating a Button

Try the action

Selection -> Select in Field

And then for

Field type Verplichting_PV

and for

String type Openstaande Verplichtingen

Thanks

Agis

2 Replies
Employee
Employee

Re: Which Action + setup for creating a Button

Try the action

Selection -> Select in Field

And then for

Field type Verplichting_PV

and for

String type Openstaande Verplichtingen

Thanks

Agis

Not applicable

Re: Which Action + setup for creating a Button

Dear Agis,

It works! Thank you very much.

Regards,

Kees-Jan

Community Browser