topic Re: How to create Table with Customer Name Where order Total is ZERO in QlikView

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

Fri, 25 Mar 2016 06:14:36 GMT

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

CUSTOMER QVD

Thanks

Chanty4u — Fri, 25 Mar 2016 06:23:17 GMT

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';

tresB — Fri, 25 Mar 2016 06:27:29 GMT

PFA

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

Kushal_Chawda — Fri, 25 Mar 2016 06:28:36 GMT

try creating the straight table

Dimension as CustomerName

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

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

Fri, 25 Mar 2016 06:33:00 GMT

Thanks ..

Kushal_Chawda — Fri, 25 Mar 2016 06:37:23 GMT

Welcome