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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

1 Solution

Accepted Solutions
paulyeo11
Master
Master
Author

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 

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

My QVW file

tresesco
MVP
MVP

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
Master
Master
Author

Hello Tres

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

Paul

paulyeo11
Master
Master
Author

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