topic Re: multiple button actions not working as expected in QlikView

multiple button actions not working as expected

Tue, 08 Nov 2016 10:49:04 GMT

Hi,

I have a very common issue. I have to clear a field on button action and then select the same field on the same button action.

Two actions have been added:

1. Clear field : Say Month

2. Select in Field : Month Value: concat({<Flag_YTD={'1'}>}Month )

3.Set Variable : vCount Value : count(distinct ({<Flag_YTD={'1'}>}Month)

We have time periods buttons QTD and YTD.

So as I move from QTD......to YTD.

say in QTD vcount was 1. Even in YTD vCount is coming as 1.

If I double click on the button . It works.

Does anyone has any solution to this issue .

Re: multiple button actions not working as expected

antoniotiman — Tue, 08 Nov 2016 11:04:11 GMT

Hi,

try

Select in Field : Month

Value :

='('&count(distinct ({<Flag_YTD={'1'}>}Month,'|')&')'

Regards,

Antonio

Re: multiple button actions not working as expected

Tue, 08 Nov 2016 11:08:26 GMT

Hi Antonio,

You did not get my issue. I am able to select the Months.

But vCount is not getting refreshed.

Thanks

Re: multiple button actions not working as expected

Anonymous — Tue, 08 Nov 2016 11:08:59 GMT

Hi ,

Can you explain your issue clearly .

Re: multiple button actions not working as expected

Tue, 08 Nov 2016 12:21:44 GMT

attached a sample application for same.

When i move from test1 to test 2 .

vTest=0

If i gain press buttopn

VTest=8.

How can this be handled in one click

Re: multiple button actions not working as expected

leni_harishwara — Tue, 08 Nov 2016 12:30:44 GMT

If possible can you share a sample file?

Regards,

Leni

Re: multiple button actions not working as expected

marcus_sommer — Tue, 08 Nov 2016 13:40:35 GMT

Multiple actions within one button won't be mandatory executed sequentially in the order that they are determined - therefore you couldn't get a real stable solution with them if they are depending from eachother.

I think the reason is that they could be applied/calculated multi-threaded - and some of them might be faster as other (depending on further calculations on the machine and how the OS and qlik switched between the cores).

If it (always) worked by the second time I think it's caused by the qlik caching which avoids a new calculation and is faster. Maybe it could be helpful (for only one click) if you not calculate the selections-values within the action else within a variable and used then this variable for the action ...

- Marcus