topic Variables and comparisons in QlikView

Variables and comparisons

Anonymous — Wed, 11 Dec 2013 18:30:48 GMT

Hi Community, I've a problem with my QV model: I would like to make a comparison between a variable and a value from a specific field, in the following way:

if(FT_FattureT.NettoTot >= $(vFattTot),1,0)

(this is an extract from a linear table, where I would like to show a light signal green when the >= is true, red otherwise)

So the question is : why does it not work when I choose a floating point number for the vFattTot, such as 545,56? While it works well when I choose simply 545??

The field FT_Fatture.NettoTot contains floating point values...

Thanks to everyone is answering! ...And sorry for my English!

Re: Variables and comparisons

Anonymous — Wed, 11 Dec 2013 19:01:46 GMT

Hi,

you try

if(FT_FattureT.NettoTot >= '$(vFattTot)',1,0)

Re: Variables and comparisons

Wed, 11 Dec 2013 19:04:23 GMT

Hello Irene,

Make Sure in your script inicial variable has a "," as Decimal Step (SET DecimalSep=','; ) because if this variable is declared "SET DecimalSep='.'; " it does not work.

You have two ways:

1.- In your variable vFattTot use 545.56

2.- Change "." for ","

Best regards.

Re: Variables and comparisons

Anonymous — Mon, 16 Dec 2013 10:24:22 GMT

Hi Oswaldo, thank you for the answer, in fact the problem was really the one you described me! I've found a solution the fits perfectly my model! Thanks again! Bye