Display Table with no Data

ch_riadh — Sat, 16 Nov 2024 19:49:19 GMT

Hi,

I have an excel with 2 sheets:

Sheet 1 : Stock table with 3 fields : (Location_Key , Date, Stock_QTY)

Sheet 2 : Location Table whit 2 field : ( Location_Key, Location)

Link : Location_Key

I have 2 scenarios:

1- when Location and date --------> 0 (USA - 01/10/2019).

---------> show me only that row:

2- when all the location and date with no zero like this:

------------> Show me a table with no data, like this :

Please find attached qvf and excel file (Source)

Thank you

Re: Display Table with no Data

thi_pham — Thu, 24 Oct 2019 09:56:53 GMT

Just add a table with:

Dimension:

- Date

- Location

Measure: sum(Stock)

Then,

set limitation of Location Dimension is Exact Value, <= 0. Uncheck Show Others. Select Total Function in measure = None if needed