Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
phirangi91
Not applicable

Making cross table in qliksense

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?

  

DateJan'15Feb'15Mar'15Apr'15
Dealer Stock11041218996942
Manufacturer Stock282721526829
UnDanned cars >30 days-54-41-71-43
1386193915221771

This is Data as given

What i made manually with given data is this:

    

DateDealer StockManufacturer StockUnDanned cars >30 days
Jan'151104282-54
Feb'151218721-41
Mar'15996526-71
Apr'15942829-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??

4 Replies
sunny_talwar
Not applicable

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

));

Michael_Tarallo
Not applicable

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

Regards,
Mike Tarallo
Qlik
phirangi91
Not applicable

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

sunny_talwar
Not applicable

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