Discussion Board for collaboration on QlikView Scripting.
I have a table as below:
and I need to have a transposed table generated by the script as below:
In other word, I need to define, in the script, the name of a field by a formula.
Do you think it's possible ?
Any idea ?
Go to Solution.
Load * Inline
Name, Type, Count
X, A, 1
X, B, 2
Y, A, 3
Y, C, 4
Z, A, 5
Z, C, 6
Z, D, 7
DROP Tables Test.A,Test.B,Test.C,Test.D;
why you want to do this in the script?
Isnt better to do in a pivot table in QlikView?
If you import a Excel file you cando this:
Directory;LOAD F2, F3, F5, F7,
FROM[..\External Data\test.xls](biff, embedded labels, table is A$, filters(Transpose(),Transpose(),Transpose()));
Have a look for the second step of importation:
I need to export the result by .qvd, it's why I want it in the script (unless there is a possibilties to export a pivot table into .qvd ???)
Unfortunately, the source is not an Excel but directly from a data base
it's works !!!!
What does it means "Resident Test.B" ???
Please refer the link for more drtails about generic load.
The Generic Load