Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
020play
Contributor
Contributor

Calculating individual rows in tables

Hi all, I'm new to QlikSense and have had trouble working on a particular table. This would be used to determine team members and their individual sales value, in addition to the total sales from the team. Ideally, it would look like this:

TOTALS1,000,000.00

Member A

250,000.00
Member B250,000.00
Member C400,000.00
Member D

100,000.00

 

I used the tutorials for aggregate tables and could not find any unique or special commands in the app. It was able to do this no problem. However, when I set Members as a dimension and Sales as a measure of summation, my output was:

TOTALS1,000,000.00

Member A

1,000,000.00
Member B1,000,000.00
Member C1,000,000.00
Member D

1,000,000.00

 

I feel like a special expression is required, and I've tried one string;

=Sum({SalesRep = {'SalesRep'}}Sales)

I have undefined outputs and am browsing a variety of tutorials wherever I can find them to gain more understanding. If possible, how would I add more columns to the table so I can quantify additional metrics such as customers served or orders processed? Any leads or examples would be appreciated.

1 Reply
AshutoshBhumkar
Partner
Partner

Hello,

Could you please provide some sample data from your table.

 

Thanks,

Ashutosh