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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-06-30 07:12 AM

help with sum in straight table

I created a straight table in which I added 5-6 expressions now I want to have a total for those respective columns.

In the total mode ,I want to  have sum as "Expression total" but when I do that I am getting "-" as total and when i am selecting "sum of rows" it is working fine,even though there are some nulls in the rows.However I want it as expression total (so as to match the total sum and also because it does not change with selection of the rows).

Thanks Guys!

344 Views
0 Likes
2 Replies
sunny_talwar
MVP
MVP
‎2015-06-30 07:17 AM

What does your expression look like? Can you share the list of your expressions?

286 Views
0 Likes
datanibbler
Champion
Champion
‎2015-06-30 07:19 AM

Hi,

you are selecting the total you want on the "expressions" tab of the dialog, right?

Could you post your app or at least tell us what are your expressions?

That would make it easier to make an educated guess at why it's not working.

It might have to do with the NULL values - is there a numeric 0 or are those cells just blank or what is in there?

HTH

286 Views