Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

helderoliveira
New Contributor

Challenging inventory (QlikSense) - Help please

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

3 Replies
bvk
Contributor II

Re: Challenging inventory (QlikSense) - Help please

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

helderoliveira
New Contributor

Re: Challenging inventory (QlikSense) - Help please

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

bvk
Contributor II

Re: Challenging inventory (QlikSense) - Help please

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