how to show inventory data not existed sales in a date

[#1]

hi,

when it join to sales table between inventory table

sales table has 'sales_date' coulumn but inventory table is not.

i have selected some date in 'sales_date' field then

it was showed  sales and inventory data only existed sales in date i selected..

i liked to show all inventory data if not existed sales in that date.

these table's coulmn is followings

[sales]

item_cd,

sales_date,

sales_qty,

sales_amount

[inventory]

item_cd,

inventory_qty,

ineventory_amount

[calendar]

date as sales_date,

week_day,

year,

month

how can i solve this matter?

please help me!

Regards,

[#2]

I solved this matter myself by usein set function like this

/sum({<sales_date=>} inventory_qty)

for reference...

[sujeetsingh]

Good try ...a good way...to get any thing in Qlikview.