Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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

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

));

Employee
Employee

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
Contributor III
Contributor III

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

Try this:

Table:

LOAD *

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

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