topic Re: Flags ? in QlikView

Flags ?

Thu, 27 Nov 2014 04:49:46 GMT

HI All,

How to use flags in qlikView ?

What are various ways to use ?

Can any one share some examples...

Thanks,

Heather

Re: Flags ?

Thu, 27 Nov 2014 04:54:55 GMT

flags are used when updating the records using incremantal load..

Re: Flags ?

its_anandrjs — Thu, 27 Nov 2014 06:59:00 GMT

Hi Heather,

Assume the simple example suppose you have dates and you need to find which date is equals to monthstart date in the load script then create another flag field as MonthstartFlag for find the

LOAD SBUName,ComiDate,MonthStart(ComiDate) as MonStart;

LOAD * Inline

[

SBUName,ComiDate

A,8/1/2014

B,9/17/2014

C,10/1/2014

D,11/22/2014

];

NoConcatenate

LOAD SBUName,ComiDate,if(ComiDate=MonStart,1,0) as MonthstartFlag

Resident A;

DROP Table A;

Regards

Anand

Re: Flags ?

ashfaq_haseeb — Thu, 27 Nov 2014 07:29:02 GMT

Hi,

Check if this helps

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ