Vijay87
Contributor
2022-06-14
04:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Showing sum() values
QlikView/QlikSense
ProductName | ProductSales |
A | 50 |
B | 60 |
C | 100 |
A | 20 |
D | 80 |
B | 120 |
E | 40 |
I have table, ProductName and ProductSales. Here repeated Productname I have, in front end I would I show the ProductSales A=70(50+20), B=180(120+60).
Your response and support give me strength and courage.
Thanks for the Advance.
297 Views
1 Reply
Marijn
Creator II
2022-06-14
05:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Vijay87
Create a chart in qlikview, choose the straight table. Use only ProductName as dimension, then create an expression with sum(ProductSales). That should do the trick.
Regards,
Marijn