Discussion Board for collaboration on QlikView Scripting.
I have below code work fine , i don't to duplicate create dat Year YearMonth for both table , i want to create a common script just for time line , may i know how can i modify ?
day(date_time) as [day],
year(date_time) as [Year],
Date(Monthstart([date_time]), 'YY MMM') as YearMonth;
select * from record_produksi_plc;
Date(Monthstart([date_time]), 'YY MMM') as YearMonth,
Pick(Match(kode_reject, 5, 39), 'reject human error', 'reject machine error') AS DESC_REJECT;
SQL select * from record_reject_detail_plc;