Discussion Board for collaboration on QlikView Scripting.
I have a table like this:
I want to transpose that table, so my expectation output should be like this:
Could you show me the best practice or script solution to have an output like above?
Herewith I attach my source data.
CrossTable(DATE, VALUE, 5)
(ooxml, embedded labels, table is Source, filters(
Date(RANGE) as RANGE,
Date(Num#(DATE)) as DATE,
Num(VALUE) as VALUE
DROP Table Table;