Button is not working as expected in QlikView

[shashipraband]

Hello Experts,

I am trying to create a variable in load script and use this in a button in the frontend, but it is not working as expected. Please help with this.

Scenario:

Step 1. Created the below variable

Set vBillion=0;

Step 2. Created the below-calculated field in the script using the preceding load.

if($(vMillion)=1, [40 Total]/1000000, Num([40 Total],'#,##0')) as Primary;

>> Once the script is reloaded I can see the created variable and the field both in UI.

Step 3.  Then created a button to get the field as divided by 1Billion in the chart.

Chose the action as 'Set Variable' and given the variable as vMillion and provide the value  as

If(vMillion=1, 0, 1)

>> If I click on the button then the Primary field is not coming as divided by millions.

Note: This is working in UI when I create a variable in frontend and the dimension also in frontend.

Please help.

Regards

Shashi

[m_woolf]

You need an "=" in front of If(vMillion=1, 0, 1)