-
Re: Making cross table in qliksense
May be try with a Transpose():
Table:
LOAD Date,
Jan'15,
Feb'15,
Mar'15,
Apr'15
FROM
[https://community.qlik.com/thread/230247]
(html, codepage is 1252, embedded labels, table is @3, filters(
Transpose()
));
-
Re: Making cross table in qliksense
Hi Sunny,
Thanks for suggestion. If i create connection of web file and export it its working but if i take from source file which is in excel its giving me error?
Following code is for reference:
Table:
LOAD
"Date",
"Dec'13",
Jan,
Feb,
Mar,
Apr,
May,
Jun,
Jul,
Aug,
Sept,
Oct,
Nov,
Dec,
"Jan'15",
"Feb'15",
"Mar'15",
"Apr'15",
"May'15",
"Jun'15",
"Jul'15",
"Aug'15",
"Sep'15",
"Oct'15",
"Nov'15",
"Dec'15",
"Jan'16",
"Feb'16",
"Mar'16",
"Apr'16",
"May'16",
"Jun'16",
"Jul'16"
FROM [lib://XYZ/Dummy_Name.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)],filters(Transpose());
-
Re: Making cross table in qliksense
Try this:
Table:
LOAD *
FROM [lib://XYZ/Dummy_Name.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)],filters(Transpose());
-
-
-
Re: Making cross table in qliksense
Hello Mandar,
Take a look at this video # 1 and # 2:
Power of Qlik Script - Reshaping Data with Crosstable (video)
Let us know how you do.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik