topic Re: Calculate dimension for pie chart in QlikView

Calculate dimension for pie chart

bvmike2001 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following scenario:

one Customer table and one Sales table; linked together in the model by Customer_ID, let's say

I need to create a pie chart that count the # of Customers over a dimension with these segments:

- No Sales

- with Sales

The expression is simple: count(distinct Customer_ID)

The issue is that the calculated dimension and the expression doesn't return anything for "No Sales" so the pie chart only display the # of Customers with Sales.

Is it possible to solve it without any joins in the model?

Regards,

Mihai

Re: Calculate dimension for pie chart

Clever_Anjos — Thu, 05 Oct 2017 10:57:16 GMT

Please try with a dimensionless pie chart adn 2 expressions

Exp1: count(distinct {<Customer_ID={"=Sum(Sales)=0"}>}Customer_ID)

Exp2: count(distinct {<Customer_ID={"=Sum(Sales)>0"}>}Customer_ID)

I´m assuming that your metric field is called "Sales"

Re: Calculate dimension for pie chart

Kushal_Chawda — Thu, 05 Oct 2017 11:01:27 GMT

what is calculated dimension?

Re: Calculate dimension for pie chart

bvmike2001 — Thu, 05 Oct 2017 11:11:13 GMT

I've try it and didn't get the expected result. I will add some more details: Cust: load * Inline [ Cust_Id, Name 1,A 2,B 3,C 4,D ]; Sales: load * Inline [ Cust_id, Sales 1,100 2,20 3,30 ] The pie chart should count 3 customers with sales and 1 customer without sales. Regards, Mihai

Re: Calculate dimension for pie chart

Clever_Anjos — Thu, 05 Oct 2017 11:30:26 GMT

It seems correct to me

Re: Calculate dimension for pie chart

Clever_Anjos — Thu, 05 Oct 2017 11:31:14 GMT

PFA

Re: Calculate dimension for pie chart

bvmike2001 — Thu, 05 Oct 2017 12:50:13 GMT

Yes!

Thank you, Anjos!

Could you explain please the logic inside the set analysis? I never used such.

Re: Calculate dimension for pie chart

Clever_Anjos — Thu, 05 Oct 2017 13:00:02 GMT

Set Analysis is equivalent to a selection made into a listbox

count(distinct {<Customer_ID={"=Sum(Sales)=0"}>}Customer_ID) means

Make a selection into Customer_ID field retrieving all customers that have Sum(Sales)=0, meaning "NO SALES" at all

count(distinct {<Customer_ID={"=Sum(Sales)>0"}>}Customer_ID) means

Make a selection into Customer_ID field retrieving all customers that have Sum(Sales)>0, meaning this customer have had sales