Problem with scatter chart

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

Hello guys,

I have problems with my scatter chart. Here it is:

There is an obvious difference in the amounts.

Here are my formulas:

DIMENSIONS

- Vendor

=if(vNSMonth>0 and vNSWeek=0,
(if(aggr(Count(DISTINCT Invoice_V),Year,Month,Vendor_Name)>=vNSMonth,Vendor_Name)),


if(vNSMonth=0 and vNSWeek>0,


(if(aggr(Count(DISTINCT Invoice_V),Year,Month,Week,Vendor_Name)>=vNSWeek,Vendor_Name))


))

EXPRESSIONS

- Net Amount(X axis): Sum ([NetAmount_V])

- Purchase count(Y axis😞 count (Distinct [Invoice_V])

- Net Amount(Z axis😞 Sum ([NetAmount_V])

Thanks,

Todor

topic Problem with scatter chart in QlikView

Problem with scatter chart