-
Re: Making cross table in qliksense
Sunny Talwar Aug 24, 2016 8:22 AM (in response to Mandar Sansare)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
Mandar Sansare Aug 26, 2016 1:39 AM (in response to Sunny Talwar )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
Sunny Talwar Aug 26, 2016 6:46 AM (in response to Mandar Sansare)Try this:
Table:
LOAD *
FROM [lib://XYZ/Dummy_Name.xlsx]
(ooxml, embedded labels, table is [Sheet1 (2)],filters(Transpose());
-
Community_230247.qvf 176.0 K
-
Community_230247.xlsx 9.1 K
-
-
-
-
Re: Making cross table in qliksense
Michael Tarallo Aug 24, 2016 2:02 PM (in response to Mandar Sansare)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