Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser22
Creator II
Creator II

Combine two sum statements in chart expressions

HI

I am new to qliksense. I have two different datasets in QVD format, I have loaded the data and trying to create a bar chart. I need to calculate the data used from both the tables. 

 

I used this expression,

=((sum({$<ChargeName= {'ABCD'}>} Qty)) / 1024 + sum([MB])/count(distinct [Phone Number]))

I don't receive an error. But I have a filter for both the tables. Like Table1, Table 2. 

So if I select Table 1 filter I need the graph should show =(sum({$<ChargeName= {'ABCD'}>} Qty)) this details with respect to DATE field. Similarly for table2. 

 

Please do help. 

0 Replies