topic Set Variable action not working as expected in QlikView

Set Variable action not working as expected

zagzebski — Fri, 20 May 2016 16:33:03 GMT

Wondering if anybody has experience the following before as I haven't.

I have a text box with the following actions with the default of vCustPremium set to "0".

1. Clear Customer field

2. Set Customers field: Premium Greater than 1000

3. Set Variable vCustPremium to: If(GetSelectedCount(Customers)=0,1,0)

My problem is that the first time I click on the text box even though after the 2nd action there are no fields with Premium greater than 1000, it still keeps vCustPremium = 0. However when I click it a second time it correctly sets the vCustPremium = 1.

Why do I have to click the button twice to get the variable to set to 1?

Thanks in advance,

Zag

Re: Set Variable action not working as expected

PabloOrtiz — Fri, 20 May 2016 16:50:51 GMT

Hi, please attach an .qvw example.

Re: Set Variable action not working as expected

tamilarasu — Fri, 20 May 2016 17:45:44 GMT

Zagzebski,

Yes. I too faced the issue once and that happened randomly. I am too curious to know the reason ans solution. If you have example, please post here. It would be helpful to confirm whether this is bug or not.

Re: Set Variable action not working as expected

sunny_talwar — Fri, 20 May 2016 17:46:32 GMT

It might be easier to see the issue with a sample. Can either of you post a document which shows the issue?

Re: Set Variable action not working as expected

tamilarasu — Fri, 20 May 2016 17:51:37 GMT

Sunny,

Sorry, I am not supposed to post my application here also the file size is nearly 5 GB. Maybe we can check with zagzebski‌.

Re: Set Variable action not working as expected

sunny_talwar — Fri, 20 May 2016 17:52:51 GMT

I was talking about a sample. A new application with just the variables

Re: Set Variable action not working as expected

tamilarasu — Fri, 20 May 2016 17:55:21 GMT

Well, I am too lazy for my own job. I will try to create a sample one.

Re: Set Variable action not working as expected

trdandamudi — Fri, 20 May 2016 18:05:09 GMT

This happened to me long back and it did happened randomly. if I remember well what I did was I cleared the field twice and then set the field value... I think that fixed the issue. I will see if I can trace that code.....

Re: Set Variable action not working as expected

tamilarasu — Fri, 20 May 2016 18:08:23 GMT

Sunny, I have tried the same procedure mentioned above in a sample application. But it's working fine in version 12. I have this issue in one of my app and the QV Version was 11.20 SR 9. Lets wait for OP's reply.

Re: Set Variable action not working as expected

sunny_talwar — Fri, 20 May 2016 18:09:11 GMT

Sounds good

Re: Set Variable action not working as expected

tamilarasu — Fri, 20 May 2016 18:18:07 GMT

Sunny, I have the issue in specific qvw file and not all the files. So, we need to test the original file.

Re: Set Variable action not working as expected

sunny_talwar — Fri, 20 May 2016 18:20:21 GMT

May be there are other triggers or actions that have contradicting effect on selections? Not really sure what could be the problem without seeing it.

Re: Set Variable action not working as expected

trdandamudi — Fri, 20 May 2016 18:32:19 GMT

Nagaraj,

I am using version 11.20 SR 9 and tested your sample file and everything looks good. As Sunny said, if there are other triggers or actions then they are contradicting... Matter of fact when I had this issue long back I do have handful of triggers and actions on each button and I had half a dozen of buttons on the sheet.

Let's see if Zag will post a sample file....

Re: Set Variable action not working as expected

zagzebski — Fri, 20 May 2016 21:40:23 GMT

File attached. Thanks.

Zag

Re: Set Variable action not working as expected

sunny_talwar — Fri, 20 May 2016 23:39:10 GMT

Step 1: Click on Property and Casualty button

You field %KeyBoBBStratification get nothing selected. Although I see a selection criteria within the button for %KeyBoBBStratification but nothing actually gets selected

Step 2: Financial button

You have this variable action

So since we did not have anything selected in %KeyBoBBStratification when we clicked on Property & Casualty, the GetSelectedCount(%KeyBoBBStratification) = 0 meaning the variable vCrossSellNoCustomersFilter will be assigned the value 1.

But also notice that when you clicked Financial for the first time C got selected in %KeyBoBBStratification. So now if you select Financial button one more time, you will see 0 because now the GetSelectedCount(%KeyBoBBStratification) = 1

Not sure if this can be fixed by just fixing the action within Property and Casualty button which will make certain selection in %KeyBoBBStratification, but that is where I would start my troubleshooting.

Best,

Sunny

Re: Set Variable action not working as expected

tamilarasu — Mon, 23 May 2016 13:04:12 GMT

Sunny, Thirumala,

Yes. I too have many triggers in my application. I'll check and try to find the reason when I get time. Thank you guys for the suggestion.