topic Re: Triggers applied using button - urgent help in QlikView

Triggers applied using button - urgent help

Wed, 22 Feb 2012 12:11:46 GMT

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..

Triggers applied using button - urgent help

CELAMBARASAN — Wed, 22 Feb 2012 12:16:45 GMT

Hi,

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

Hope it helps

Celambarasan

Triggers applied using button - urgent help

vijay_iitkgp — Wed, 22 Feb 2012 12:19:26 GMT

Hi,

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

Re: Triggers applied using button - urgent help

Wed, 22 Feb 2012 12:19:27 GMT

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

Thanks

Triggers applied using button - urgent help

swuehl — Wed, 22 Feb 2012 12:21:15 GMT

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

Re: Triggers applied using button - urgent help

CELAMBARASAN — Wed, 22 Feb 2012 12:22:02 GMT

Hi,

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

Celambarasan

Triggers applied using button - urgent help

vijay_iitkgp — Wed, 22 Feb 2012 12:22:37 GMT

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

Sum({$<Status =>} Sales)

Re: Triggers applied using button - urgent help

Wed, 22 Feb 2012 12:30:12 GMT

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 ???

Re: Triggers applied using button - urgent help

CELAMBARASAN — Wed, 22 Feb 2012 12:33:43 GMT

Hi,

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

Celambarasan

Re: Triggers applied using button - urgent help

Wed, 22 Feb 2012 12:34:20 GMT

Hi Vijay,

yes that was helpful..

Thanks

Re: Triggers applied using button - urgent help

CELAMBARASAN — Wed, 22 Feb 2012 12:35:39 GMT

Hi,

If you got output correctly in your approach then you can continue with yours option itself.

Celambarasan

Re: Triggers applied using button - urgent help

Wed, 22 Feb 2012 12:39:56 GMT

Thank u so much Celembarasan..

It works fine..