Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
Kushal_Chawda

try creating the straight table

Dimension as CustomerName

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

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

View solution in original post

5 Replies
Chanty4u
MVP
MVP

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
MVP
MVP

PFA

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

Kushal_Chawda

try creating the straight table

Dimension as CustomerName

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

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

Not applicable
Author

Thanks ..

Kushal_Chawda

Welcome