Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Flags ?

HI All,

How to use flags in qlikView ?

What are various ways to use ?

Can any one share some examples...

Thanks,

Heather

3 Replies
Not applicable

Re: Flags ?

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

Re: Flags ?

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

A:

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

N:

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

Resident A;

DROP Table A;

Flag.png

Regards

Anand

Re: Flags ?

Hi,

Check if this helps

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

Regards

ASHFAQ

Community Browser