Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Triggers applied using button - urgent help

Hi All,

I have a four buttons in a single sheet , based on the selection of buttons the charts are shown up uisng Layout condition. I have a button called sales in which if I click on the button five charts should come up (4 Bar charts and one  Table box) . I need to populate fiew fields in the Table box out of which I have a field named Status  (which has True and False as values) . I need to show only true values in the table box but as i cant apply any conditions in the table box I am not sure how to do this..

If you have any better approaches for implementing  the same plz share..

Awaiting for the reply..

Thanks in advance..

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use Status in Expression like =if(STATUS='TRUE',1) instead of 1.

Celambarasan

View solution in original post

11 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     On that button use the action Select in field with FieldName as Status and search string as True.

Hope it helps

Celambarasan

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

You can add a trigger  Selection on button Sales. In  Filed put Status and in Search String put True/Flase whatever u need.

Not applicable
Author

The problem is the condition  (TRUE) gets applied for all teh charts instead of applying only to table box which i dnt want..

Thanks

swuehl
MVP
MVP

Why not use a straight table instead of a table box, with calculated dimension or set expression to limit status to TRUE?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Then you can go for straight table instead of table?any specific reason to use table box here?

Celambarasan

vijay_iitkgp
Partner - Specialist
Partner - Specialist

In All oher chart use set analysis to ignore Status Field :Eg

Sum({$<Status =>} Sales)

Not applicable
Author

Yes. I have changed it to Straight table with expression as 1 and hide the  expression.. Also I have added the calculated dimension on the Status filed to pick only (TRUE) values.. Hope this is correct ???

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Use Status in Expression like =if(STATUS='TRUE',1) instead of 1.

Celambarasan

Not applicable
Author

Hi Vijay,

yes that was helpful..

Thanks