Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
WANNAONE
Contributor
Contributor

SUM the total revenue of a customer in a table by ignoring product sub-set

I want to make Table1 in App. (I don't want to make it as Pivot.)

it is easy to get 2020 Revenue @ Customer & Product.

how should I get 2020 Revenue  @ Customer ?

Table1

CustomerProduct2020 Revenue @ Customer & Product
=SUM({$<YEAR={2020}>})Revenue
2020 Revenue @ Customer
AP1=200+400+800+1600=200+400+800+1600+100+200+400+800
AP2=100+200+400+800=200+400+800+1600+100+200+400+800
BP1=2000+4000+8000+16000=2000+4000+8000+16000

 

raw data

CustomerProductRevenueYearQuarter
AP11002021Q1
AP2502021Q1
BP110002021Q1
AP12002020Q1
AP21002020Q1
BP120002020Q1
AP14002020Q2
AP22002020Q2
BP140002020Q2
AP18002020Q3
AP24002020Q3
BP180002020Q3
AP116002020Q4
AP28002020Q4
BP1160002020Q4

 

Thanks

1 Solution

Accepted Solutions
1 Reply