topic Re: Flag field based on another table in QlikView

Flag field based on another table

Mon, 08 Aug 2011 12:09:51 GMT

Hi All

I would like to add a field to Table A based on the fourmula (IF(WeekDayNUmber = 3, 1,2), However WeekDayNumber is a field in Table B. Any advice on hwo best to go about thsi woudl be great. Please see the atatched test document.

Thanks

Dan

Flag field based on another table

SunilChauhan — Mon, 08 Aug 2011 12:58:37 GMT

A:
LOAD DateActual
FROM
Test.xls
(biff, embedded labels, table is A$);

B:
LOAD DateActual,
     WeekdayNumber,
     DayOfMonthNumber,
     CYDayOfYearNumber,
     CYWeekOfYearNumber,
     CYMonthNumber,
     [CY Quarter],
     [CY Year],
     [CY Year Month],
     [CY Year Month Name],
     [CY Year Month Short],
     [CY Year Quarter],
     FYDayOfYearNumber,
     FYWeekOfYearNumber,
     FYMonthNumber,
     [FY Quarter],
     [FY Year],
     [FY Year Month],
     [FY Year Month Name],
     [FY Year Month Short],
     [FY Year Quarter],
     [Out of Hours]
FROM
Test.xls
(biff, embedded labels, table is B$);

left Join(A)

Load DateActual,
WeekdayNumber as WeekdayNumber1
resident B;

C:
Load
DateActual

if(WeekdayNumber1=3,1,2) as Flag
resident A;

drop table A;

Flag field based on another table

Mon, 08 Aug 2011 14:36:29 GMT

Hi Thanks

for the reply. WOuld this be the same if i were loading my tables from MS Access? It does not seem to like :

left Join(A)

Load DateActual,
WeekdayNumber as WeekdayNumber1
resident B;

thanks again

dan

Re: Flag field based on another table

Mon, 08 Aug 2011 14:36:53 GMT

Hi Thanks

for the reply. WOuld this be the same if i were loading my tables from MS Access? It does not seem to like :

left Join(A)

Load DateActual,
WeekdayNumber as WeekdayNumber1
resident B;

thanks again

dan

Re: Flag field based on another table

Mon, 08 Aug 2011 14:42:16 GMT

sorry it does work. thanks

dan