Making cross table in qliksense

[Anonymous]

Hey ,

As a requirement i have to work on this data for emergency purpose i did make some manual changes in file and completed my task.

But i was wondering how to create cross table in qliksense?

Date	Jan'15	Feb'15	Mar'15	Apr'15
Dealer Stock	1104	1218	996	942
Manufacturer Stock	282	721	526	829
UnDanned cars >30 days	-54	-41	-71	-43
	1386	1939	1522	1771

This is Data as given

What i made manually with given data is this:

Date	Dealer Stock	Manufacturer Stock	UnDanned cars >30 days
Jan'15	1104	282	-54
Feb'15	1218	721	-41
Mar'15	996	526	-71
Apr'15	942	829	-43

I'm trying to do it through sense scripting, Any help will be appreciated.

Also is it possible to make stacked bar chart with value on segments of given data points??

[sunny_talwar]

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()

));

[Michael_Tarallo]

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

[Anonymous]

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());

[sunny_talwar]

Try this:

Table:

LOAD *

FROM [lib://XYZ/Dummy_Name.xlsx]

(ooxml, embedded labels, table is [Sheet1 (2)],filters(Transpose());