Discussion Board for collaboration related to QlikView App Development.
How do I create a flag that gives me every person who doesn't have any start or end dates (both must be empty)?
The table below, should only return Person 2, as there are zero dates on that person.
Go to Solution.
Date#(Start, 'MM-DD-YYYY') as Start,
Date#(End, 'MM-DD-YYYY') as End,
(html, codepage is 1252, embedded labels, table is @1);
If(Sum(Start) = 0 and Sum(End) = 0, 1, 0) as Flag
Group By Person;
View solution in original post
use the if condition on ur start ans end date wherever the values are null u can put ur flag else the source date.