topic Re: Creating a binary flag in QlikView

Creating a binary flag

Anonymous — Thu, 18 May 2017 10:00:42 GMT

Have a requirement,need to create a field in the script wth 3 defined range so that if it's 1st range it Shud give 1 else 2 or 3 ,how to do that.

Re: Creating a binary flag

prieper — Thu, 18 May 2017 10:06:02 GMT

create an expression like

LOAD

IF(MyCheckField < 100, 1, IF(MyCheckField < 1000, 2, 3)) AS Range

FROM ....;

Edith would like to add that a field with content 1, 2, 3 is not a binary field ...

Peter

Re: Creating a binary flag

vinieme12 — Thu, 18 May 2017 10:28:44 GMT

can you give an example?

Re: Creating a binary flag

Anonymous — Thu, 18 May 2017 10:34:25 GMT

ok and also i would like to create this field as it doesnt exist in my script.

how to and where to do that.

Re: Creating a binary flag

Peter_Cammaert — Thu, 18 May 2017 10:35:46 GMT

Or without nested IF() calls:

LOAD ...

Match(-1, FieldToCheck<1000, FieldToCheck<2000, FieldToCheck>=2000) AS Flag,

...

The ranges can be made variable by defining two border variables and $-sign substituting them in the Match() call.

Best,

Peter

Re: Creating a binary flag

Peter_Cammaert — Thu, 18 May 2017 10:39:21 GMT

In Peter's example, the field is created in the script as Range.

You can't create fields outside of your load script.

You can however create a value column on the fly in an UI object by using the same expression without the AS Range part in a Calculated dimension or a simple expression column.