Straight table, same value for each SKU

Tue, 23 Feb 2016 09:00:27 GMT

Hi,

This is where I started from. I have straight table that gives current inventory value for each SKU.

I need to add new date dimension that doesn't exist for inventory data. When I add it, inventory value is 0 for each date dimension rows and there is a null field that has all the inventory in it. How can I replicate the inventory value for each sku rows so it ignores the required date field?

Expression is following:

sum({< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])

Re: Straight table, same value for each SKU

sunny_talwar — Tue, 23 Feb 2016 17:42:09 GMT

Try this:

Sum(TOTAL <SKU> {< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])

topic Re: Straight table, same value for each SKU in QlikView

Straight table, same value for each SKU

Re: Straight table, same value for each SKU