topic Re: 14 Days Flag in QlikView

14 Days Flag

ilanbaruch — Sun, 04 Oct 2015 08:40:49 GMT

Hi All,

I'm trying to create a flag field (0/1) base on a condition like: if (condition,1,0) as flag

I want the flag to be true (flag = 1) for 14 days disregarding any condition.

in other words once flag=1 for 14 days than becomes flag = 0 again.

any ideas ?

thank you

Ilan

Re: 14 Days Flag

marcus_sommer — Sun, 04 Oct 2015 09:17:59 GMT

You mean something like:

if(Date >= today() -14, 1, 0) as flag

maybe within your fact-table unless you creates a master-calendar new with each reload - then it would be better within the calendar-dimension-table.

- Marcus

Re: 14 Days Flag

Anonymous — Sun, 04 Oct 2015 09:34:32 GMT

hi,

Maybe:

if(Interval(Today() - Date,'dd') <= 14,1,0) as Flag

Regards

Neetha

Re: 14 Days Flag

ilanbaruch — Sun, 04 Oct 2015 09:45:09 GMT

Hi Marcus,

thanks for your quick replay.

the default condition for the flag is not based on date or days its something like:

if (amount >=150,1,0) as flag

but the flag needs to be there only for 14 days disregarding any condition, than 0 again.

Re: 14 Days Flag

ilanbaruch — Sun, 04 Oct 2015 10:07:55 GMT

Hi All,

thanks for you're quick replay.

the default condition for the flag is not based on date or days, its something like:

if (amount >=150,1,0) as flag

but the flag needs to be there only for 14 days disregarding any condition, than 0 again.

Re: 14 Days Flag

qlikviewwizard — Sun, 04 Oct 2015 11:54:36 GMT

Hi,

You can use either one.

Re: 14 Days Flag

MarcoWedel — Sun, 04 Oct 2015 12:15:24 GMT

-(Date>=Today()-13 and Date<=Today()) as flag

Regards

Marco

Re: 14 Days Flag

Anonymous — Sun, 04 Oct 2015 13:35:59 GMT

hi,

Maybe try:

if( amount >=150 and Date >= today() -14, 1, 0) as flag

Regards

Neetha

Re: 14 Days Flag

MarcoWedel — Sun, 04 Oct 2015 20:31:26 GMT

-(Date>=Today()-13 and Date<=Today() and amount>=150) as flag

regards

Marco