=Sum(Aggr(Only(Rate)*Sum(sales), YearMonth)) Cannot display all company result

[paulyeo11]

Hi All

I have 2 Table.

Table 1 with below expression :-
=Sum(Aggr(Only(Rate)*Sum(sales), YearMonth))

Table 2 with below expression :-
=Sum(sales)

Why Table 1 only display one company sales amount ?

Paul

[paulyeo11]

My QVW file

[tresesco]

Because, in expression you did not mention your chart dimension SOURCE as aggregation field. I don't know why you are using the expression Sum(Aggr(...? If you can explain your expected output - may be we can try and help. 

[paulyeo11]

Hello Tres

Thank you for your help. I need to prepare a self loading script to describe to my issue. Pls wait.

Paul

[paulyeo11 · Accepted solution]

Hi Sir

Can you help me look at my post below :-

https://community.qlik.com/t5/QlikView-Layout-Visualizations/How-to-add-new-SOURCE-with-exchange-rat...

I still unable figure out how to create monthly exchange Rate for Malaysia Currency.

Paul