Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vince_CH
Creator III
Creator III

Scatter chart results different from table results

Hello Community,

I have scatter chart like following, with table besides as comparison, with both expression of sales are same as below, but you can see for same category of item, the sales amount are different with the scatter chart result being over 25M, and table result to be over 16 M only.  Any expert can give me some hint on this?  thanks!

Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GF'},FiscalYear_Orderinv={"$(='>='&'2018')"}>}Aggr(Order_Total_Value_Net_Local_Curreny,[Order No.],[Item Number]))

For scatter chart, the expressions of bubble dimension are as following, with tables' dimensions you can see from picture as fiscalyear, fiscalmonth, ordertype, category, customer name etc.

If(Order_Material_Pricing_Group_Text='spare parts' or Order_Material_Pricing_Group_Text='service' or Order_Material_Pricing_Group_Text='repair works' or
Order_Material_Pricing_Group_Text='grinding media', If(Subsidiary<>'Subsidiary', Order_Material_Pricing_Group_Text,'IC'&'/'&Order_Material_Pricing_Group_Text))

11.jpg

Labels (1)
1 Reply
Vince_CH
Creator III
Creator III
Author

Dear Expert, is there anyone who can help with this problem? Appreciated and thanks!