Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
TOTALS | 1,000,000.00 |
Member A | 250,000.00 |
Member B | 250,000.00 |
Member C | 400,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:
TOTALS | 1,000,000.00 |
Member A | 1,000,000.00 |
Member B | 1,000,000.00 |
Member C | 1,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.
Hello,
Could you please provide some sample data from your table.
Thanks,
Ashutosh