Flags ?

[#1]

HI All,

How to use flags in QLikView ?

[arulsettu]

hi check this

What are flags in QV?

flags

[its_anandrjs]

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;

Regards

Anand