Button is not working as expected in QlikView

shashipraband — Sun, 21 Oct 2018 05:59:09 GMT

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

Re: Button is not working as expected in QlikView

m_woolf — Mon, 22 Oct 2018 17:23:37 GMT

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