topic Re: Resident Table Error in QlikView

Resident Table Error

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Resident Table Error

Chanty4u — Thu, 31 Mar 2016 13:56:22 GMT

can u share ur excel?

Re: Resident Table Error

agustinbobba — Thu, 31 Mar 2016 14:01:58 GMT

Hi!

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

best regards,

Agustin

Re: Resident Table Error

Thu, 31 Mar 2016 14:02:10 GMT

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

Re: Resident Table Error

sunny_talwar — Thu, 31 Mar 2016 14:02:16 GMT

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

Re: Resident Table Error

sunny_talwar — Thu, 31 Mar 2016 14:05:15 GMT

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

Re: Resident Table Error

Thu, 31 Mar 2016 14:14:42 GMT

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,

Re: Resident Table Error

sunny_talwar — Thu, 31 Mar 2016 14:20:17 GMT

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;

Re: Resident Table Error

Thu, 31 Mar 2016 16:14:42 GMT

Thanks everyone for your kind and timely responses.