Resident Table Error

[#1]

Hi All,

I'm trying to make a table using the Resident Load. Unfortunately I'm getting an error. I'm bringing in the data using Excel and [42248] represent data for each month.

Please provide assistance.

[Chanty4u]

can u share ur excel?

[agustinbobba]

Hi!

I see the word "Inline", when is a resident you cant use inline statement.

best regards,

Agustin

[#4]

Please find attached. I need to add a months field in Qlik. The Months field In Excel shows the sum for the specific month.

[sunny_talwar]

This as Inline load you are doing. What exactly are you trying to do? May be you need CrossTable Load (The Crosstable Load)

[sunny_talwar]

Wow, that is a huge Excel file, would it not be possible to remove unnecessary stuff and make it smaller

[#7]

Hi Guys,

I want to add a months field. The Excel sheet shows month summed up with Sales so it can't be used as a Dimension in the chart only as a expression.

I want to make a chart where I have the months as dimensions and the sum on the expressions.

Since I can't do that in Excel I thought of doing a Resident load Inline Table and make up Months field.

Months:

Load * Inline [

Months, Data

September, Sep

October, Oct.......

]

Resident Products;

Thanks in Advance,

[sunny_talwar · Accepted solution]

Like this?

Script:

Table:

CrossTable(Month, Data)

LOAD Products,

    Sep,

    Oct,

    Nov,

    Dec,

    Jan,

    Feb

FROM

[SAMPLE - 2015 03 30.xlsx]

(ooxml, embedded labels, table is Sheet1);

FinalTable:

NoConcatenate

LOAD Products,

  Month(Date#(Month, 'MMM')) as Month,

  Data

Resident Table;

DROP Table Table;

[#9]

Thanks everyone for your kind and timely responses.