Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Re: Empty fields in table

Ok!

So,

table1 - "Inventory cost":

fields - Item, DateCome, QuantityCame, CostCame, Spending1, Spending2

table 2 - "Items movement":

fields - Item, DateMovement, InOrOut, QuantityMoved, Stock

Final table (what I want to see):

Stock, Item, AvgCost, QuantityForTheBeginning, QuantityIn, QuantityOut, QuantityInTheEnd.

Also, where the problem can sit in my opinion, the script

CalendarInventoryCameTemp:

LOAD

  Date

Resident Calendar;

Left Join (CalendarInventoryCameTemp)

LOAD

  Date as DateCome

Resident Calendar;


CalendarInventoryCame:

LOAD

  Date

  ,DateCame

Resident CalendarInventoryCameTemp;

DROP Table CalendarInventoryCameTemp;

The same script for DateMovement.

Not applicable

Re: Empty fields in table

I tried to do as you said, Jonathan, thank you.

But the result is the same. Some items is shown, and some is not. And I don't see the logic there. Because they all have the data in fields.

My intuition tells me Date making some problems there.

Please, any suggestions. 2nd day of a headache(

Community Browser