Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
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