Discussion Board for collaboration on QlikView Scripting.
I just want to ask for help in this certain document.
What will be the approach?
I have tried transforming the table using transpose, fill and finally crosstable.
I can't find the desired output.
my output should be like this:
Dept Code | Status | IP(actual) | OP(actual) | IP(budget) | OP(budget)
please see attached file.
Use below code you will get data..
F1 as [Dept Code], F2 as Status, IP as IPActual, OP as OPActual, IP1 as IPBudget, OP1 as OPBudgetFROMActual_Rev_1.xlsx(ooxml, embedded labels, header is 2 lines, table is
Thanks but I needed the Month since i still have files including January till September~
is that month coming as filename or is it a field name in your data..
If the month coming as filename then use filename function..
if possible post sample file...
the month is coming from a filename
Hey, can i have the sample file name..
Jan2012, Feb2012, Mar2012, Apr2012, Jun2012, July2012, Aug2012, Sep2012
use like this
F1 as [Dept Code], F2 as Status, IP as IPActual, OP as OPActual, IP1 as IPBudget, OP1 as OPBudget,
Filename() as MonthyearFROMActual_Rev_1.xlsx(ooxml, embedded labels, header is 2 lines, table is
still if you want only month the use
left(Filename(),3) as Month