Display Table with no Data

[ch_riadh]

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

[thi_pham · Accepted solution]

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