Discussion Board for collaboration on QlikView Scripting.
I am looking to convert data into a linear table from crosstable structure and need help. My data looks like Sheet1 and my desired output is Sheet2 in the attached excel. Any help is appreciated.
May be this
LOAD * Inline [
CrossTable (WeekDay, Value, 5)
LOAD [Week starts on],
(ooxml, embedded labels, table is Sheet1);
ApplyMap('MappingWeekDay', WeekDay, Null()) as WeekDayNum,
Date(RangeSum([Week starts on], ApplyMap('MappingWeekDay', WeekDay, Null()))) as Date
Where Value <> 0;
DROP Table Table;