topic Create a flag field in script in QlikView

Create a flag field in script

Wed, 07 Apr 2010 08:31:52 GMT

I've loaded about 2million rows with sales data into my qvw model. There are about 100 customers that need to be flagged for possible exclusion from the total. To make this exclusion optional, I'd like to create a new field flagging the 100 customers with a 'X' and all other entries 'Y'; this would allow a simple list box click to either include or exclude the 100.

Is this possible to do in the load script?

Thank you in advance.

Create a flag field in script

rwunderlich — Wed, 07 Apr 2010 09:09:40 GMT

I'm sure there is more than one way to answer this question. But a solution that comes to mind is to use a Map that assigns 'Y' to the excluded group and 'N' to all others. See attached example.

-Rob

Create a flag field in script

Wed, 07 Apr 2010 15:03:06 GMT

Thank you. This works exactly.