How to create Table with Customer Name Where order Total is ZERO

[#1]

Hi Guys,

What am I trying Achieve?

I want to get a table with All the customer name and their total number of orders.

• The table must display customer names even when there are no orders against them
• If there are no orders then that column should display '0' or 'NULL'
• NOTE: I am not using any joins when loading both QVDs.

What I have tried so far?

I have tried Pivot table and straight table in charts as below

Dimension as CustomerName

Expression as count(OrderID)

- But this is only showing customers that have placed any orders

Here is a small example of my data model

ORDER QVD

• OrderID
• OrderDate
• CustomerID
• etc..

CUSTOMER QVD

• CustomerID
• CustomerName
• etc..

Thanks

[Chanty4u]

try to load all the data  and join the table

and write a condition lik

set Nullvalue='0';

sample:

load *,

......

......

from ur datasource;

Where [order total]='0';

[tresesco]

PFA

Un-check 'Suppress Zero Values' in presentation tab.

[Kushal_Chawda · Accepted solution]

try creating the straight table

Dimension as CustomerName

Expression as alt(count(distinct OrderID),0)

Go to chart Properties->Presentation-> Uncheck Suppress zero values

[#5]

Thanks ..

[Kushal_Chawda]

Welcome