Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load data from an excel and the data is in cross table.
Please find the details in the attached excel sheet.
There are two tabs in excel sheet.
I have given sample data in source tab.
In QlikView need to create List boxes based on heading mentioned in source tab.
Details have shown in Requirement tab.
Please help on this example.
See attached example. If a user can be part of only one team use the script on the first tab instead.
See attached example. If a user can be part of only one team use the script on the first tab instead.
Hi,
Many thanks.
It worked well.
Hello Gysbert, or anyone with a full Qlikview License,
Can you post the code from your qvw on here? As I only have personal addition I cant open your file. It will solve my problem.
Kind regards
Connor
T3:
LOAD if(len(trim(A))<>0, A & '|' & B) as AB,
C,
D,
E,
F,
G,
H,
I,
J,
K
FROM
(ooxml, no labels, table is Source);
store T3 into T3.qvd;
T4:
CrossTable(TeamUser,Value,2)
LOAD * FROM
(qvd, embedded labels, filters(
Transpose()
));
T5:
load
F1 as Year,
[Team|user] as Month,
subfield(TeamUser,'|',1) as Team,
subfield(TeamUser,'|',-1) as User,
Value
Resident T4;
drop table T3, T4;
hope this helps
regards
Marco
Thanks Marco
You're welcome
regards
Marco