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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.