Challenging inventory (QlikSense) - Help please

[Anonymous]

For some reason I am not able to link an inventory cross table with the regular table (perhaps a loading issue).

The first table (worksheet) shows the products and the expected inventory levels at that point in time.

The second table (worksheet) shows products, quantity and date of arrival.

I would like to compare my receipts and the inventory balance over time to make a very simple graph that can drill down the dates (month to weeks to days) - no problem if I need to make a separate link table just to link the dates with months and weeks.

I tried it over the last few days and could not reach a solution.

Please, help me. Attached is a sample of the data I am using.

Thank you

Helder

+551598108300

[Anonymous]

Hi Helder,

You will need to load the Inventory with the crosstable directive Crosstable‌ So your load statement would look like:

[Inventory]:

CROSSTABLE (Date, Inventory)

LOAD *

FROM [lib://Downloads/qliksense_help.xlsx]

(ooxml, embedded labels, table is Inventory);

[Anonymous]

Thank you Bas Van,

The problem now is that my dates are in the worng format.

They are coming as text and are not connecting with the other spreadsheet. Do you know how to solve it?

Thank you,

Helder

[Anonymous]

Hi Helder,

You can use the Date# function for this when you load the data.

Date# - script and chart function

You will need to specify the date format as the second parameter.

Regards,

Bas