Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Annual Conference: Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nagaraj6
Contributor II
Contributor II

In Straight table Total expession not working

Hello Guys,

I need help

below screenshot  Total sales=2394566 and Total count=5463, I am dividing both then I getting wrong.please help me. I want to get expected ouput :438 

Nagaraj6_0-1687325072948.png

Nagaraj6_1-1687325554513.png

which  option should I select to get output in expression Total??

 

 

 

Labels (1)
3 Replies
Aditya_Chitale
Specialist
Specialist

Try setting total mode of total column to AUTO. or use expression total option

Regards,

Aditya

Nagaraj6
Contributor II
Contributor II
Author

Nagaraj6_0-1687328499371.png

Nagaraj6_1-1687328588298.png

 

There is no auto option and expression total also not working

 

 

MayilVahanan

Hi

Try to select "Expression Total" and verify once

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.