Aggregate value not showing in the sheet

[Faiz]

Hello,

I am struggling to get aggregated sales value in qlik sense sheet. I have three columns in the table: Document No., Item Ledger Entry No. and Sales. I want to aggregate the sales value across [Document No.]. In SQL, we write below statement to get the result.

SELECT [Document No.], SUM(Sales) FROM Table

GROUP BY [Document No.]

When I select all the three columns, I get result like shown below.

The moment I remove [Item Ledger Entry No.], I get a blank value of Sales.

I tried Sum (Sales) instead of Sales, but still no success.

I tried Sum (Total Sales) instead of Sum(Sales), but still no success. I have also changes Totals function from Auto to Sum but again there is no success.

What do I need to do in Qlik Sense to get the desired result?

[rwunderlich · Accepted solution]

Sum(SALES) should be correct. However, it looks like your SALES values have been forced to be text values (they show left justified in your table). 

Can you show the script statements used to load the SALES field?

-Rob

[Faiz]

Thanks for the reply. I checked the source table, measures are stored as string. I will try to fix the source table and see if it resolves the issue or not.

Can you please also help me in resolving the issue I raised in the link below.

https://community.qlik.com/t5/Qlik-Sense-SaaS-Multi-Cloud/Connecting-to-SQL-Server-through-Qlik-Sens... 

In the meantime