topic Changing the value of a variable in an if statement (simple question) in QlikView

Changing the value of a variable in an if statement (simple question)

Thu, 12 Nov 2009 16:19:09 GMT

I am trying to change the value of the second variable based on the value of the first but it is not working,

I would appreciate some help

($(vInvoiceEvCheck) = 0,vFcst_Invoices= 0)

Anonymous — Thu, 12 Nov 2009 16:27:39 GMT

Hi,

Try throwing it around and assign the if statement to the variable:

Let vInvoiceEvCheck=0;

Let vFcst_Invoices=if($(vInvoiceEvCheck) = 0,0);