Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sridhar1
Contributor III
Contributor III

Grand Totals in Straight Table

Hi All,

I have issue with grand totals when looking at particular order number. Below is the scenario

Sales PersonOrder NumberSales $$Total Sales $$ by Order
ABC123200500
XYZ123300500
QWE456100100
WER234250250
Grand Total8501350

Sales $$ Grand Total is looking good but Total Sales $$ by Order is adding all the numbers which is wrong it should show 850$ as well.

And we have filter to one order 123 Grand Total is showing up 1000$ which is it should show only $500.

How do I achieve this?

Thanks

Sridhar

15 Replies
sunny_talwar

Sorry, but may be somebody else might be able to help. Read what you wrote 2-3 times, but still not sure I understood.

NZFei
Partner - Specialist
Partner - Specialist

That is easy!

Fei

sridhar1
Contributor III
Contributor III
Author

Hey Fei,

What is Totals Function you used.

NZFei
Partner - Specialist
Partner - Specialist

If you don't know this function, you really need to search and learn it. We use it a lot.

It is used in chart and ignore the dimensions.

In above example, if you use sum(total [Sales $$]), you will have 850 for all the rows because it ignore all the dimensions.

If you use sum(total <[Order Number]> [Sales $$]), you ignore all the dimensions except [Order Number]. So the result is the total sales by order numbers.

Have a play and you will understand it

Fei

sridhar1
Contributor III
Contributor III
Author

I am New to Qlik Tool and Yep I agree need to learn a lot.

Thanks for your help and suggestions.

NZFei
Partner - Specialist
Partner - Specialist

No worries. Glad that I can help. Welcome to the Qlik world