topic Button Actions in QlikView

Button Actions

Fri, 11 Sep 2015 18:48:51 GMT

Hi,

I have two actions defined in the button but only the first one is taking effect. How to make both the actions working that are defined in the button?

Re: Button Actions

Fri, 11 Sep 2015 18:56:21 GMT

I figured what the issue is. This is because some of the records satisfy the first condition and some of the records satisfy the second condition but there are no records that satisfy both the conditions. Hence only one of them gets applied and the data set is returning for that one condition whichever is applied first. So, how do we solve this? Should I have both the conditions in a single action instead of having two actions?

Re: Button Actions

Fri, 11 Sep 2015 18:56:45 GMT

when you click on the button, all actions defined in the button should take place. The only time I have seen when they do not is when the action has an error and it cannot be performed

it looks lie the action that is failing is the one where you are setting a value in a list box?

I was able to get one to work by entering the value in Search String

In the attached, when I click on the button you can see the only values for the Month field are Month 1

are you using wild cards because you have multiple values with the string Testing Evidence in them?

Re: Button Actions

Anonymous — Fri, 11 Sep 2015 19:01:48 GMT

I don't see anything wrong here. Would u be able to share your app. Just delete one and check individually these select in field actions are working or not.

Re: Button Actions

Fri, 11 Sep 2015 19:07:36 GMT

I am able to get the set field to work with 2 wild cards like in the above example - Initially I had the same issue because I did not have the correct field defined.

Please check the field - the best way is to go into the editor and select and paste the field from the field selection on the bottom

Re: Button Actions

sudeepkm — Fri, 11 Sep 2015 19:09:30 GMT

I think action in one object works in sequence. the data set selected as per first action will be overridden by second action. have you checked it again. Do you have any Status values as *Testing Evidence* ?

Re: Button Actions

Fri, 11 Sep 2015 19:22:09 GMT

Basically if we give a condition in Button for which no data would fit in, when clicked, nothing gets selected in the current selection. For example, create a Button with a filter condition colA='F'; if there is no data that fits in that criteria, nothing gets displayed in current selection when the button is clicked.

In my case, no records fit in the given conditions. But some records fit in the first condition and some in the second condition but nothing for both the conditions. So, when the button is clicked, one of them is applied and the other condition does not even appear in current selection. Ideally, both should appear in the current selection and no data should be returned.

So, I am trying to integrate both the conditions in one action instead of having two actions. This is what I have but it's not working -

= '=TEST_EXPIRATION_DT1=' & TIMESTAMP(TODAY()) & '=TEST_CASE_STATUS=' & chr(39) & 'Testing Evidence' & chr(39)

Please let me know what is the missing in the above statement.

Re: Button Actions

Mon, 14 Sep 2015 16:05:41 GMT

Hi,

Do we have any update on this question. Basically, I want to implement the below condition in button -

= '=TEST_CASE_STATUS=' & chr(39) & 'Testing Evidence' & chr(39) & 'AND TEST_EXPIRATION_DT1=' & TIMESTAMP(TODAY())

But because there are no records that fit into this condition, nothing happens when the button is clicked and all data is displayed. Ideally, nothing should be displayed as no records fit into the above condition.

Is there any other way to handle this? Any other way to specify this filter condition if not in button?