topic Re: Resident Load Issue in QlikView

Resident Load Issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

Please help me with the below Resident Load.

Inventory:

LOAD [Inventory ID],

Name,

Description,

[Unit Price],

[Quantity in Stock],

[Inventory Value],

[Reorder Level],

[Reorder Time in Days],

[Quantity in Reorder],

Discontinued?

FROM

[..\..\Inventory List.xlsx]

(ooxml, embedded labels, table is Sheet1);

[Total Quantity]:

LOAD Inventory,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

Re: Resident Load Issue

michael123 — Tue, 24 Oct 2017 07:33:19 GMT

[Total Quantity]:

LOAD Name,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

Re: Resident Load Issue

prma7799 — Tue, 24 Oct 2017 07:35:25 GMT

from where inventory field come from ??

Try like this...

Total Quantity]:

LOAD Name,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

Re: Resident Load Issue

avinashelite — Tue, 24 Oct 2017 07:38:44 GMT

The below portion has the issue

[Total Quantity]:

LOAD Inventory,

Sum([Unit Price])*Sum([Quantity in Stock]) as Total Resident Inventory Group by Name;

Group by should be always on the columns which acts a key ...and it should be part of the loading table in you case its different

Re: Resident Load Issue

Anonymous — Tue, 24 Oct 2017 07:51:50 GMT

Thanks for making understand

Re: Resident Load Issue

Anonymous — Tue, 24 Oct 2017 07:52:01 GMT

Thanks verymuch

Re: Resident Load Issue

avinashelite — Tue, 24 Oct 2017 07:54:59 GMT

Don't forget to mark the helpful and correct answers