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: 
Not applicable

Total is not comming properly in the chart

Hi All,

I am using a Pivot table and using Partial Sum options for Totals. For column 2 it is coming perfect but for column 1 it is not coming and just showing '-' and then I replaced that '-' with '0' but still the Total is not coming.

Can anyone help me out with this problem?

PS : I have attached the Image for that chart.

Thanks!!!

- Yojas

10 Replies
Sokkorn
Master
Master

Hi Yojas,

Use NumSum() instead of Sum()

Regards,

Sokkorn

Not applicable
Author

Hi,

When you try to add values to null() it will result in giving null() values.

Try using if(isnull(exp1),0,exp1).

HTH

-Shruti

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

You are probably using a field directly in the expression. This evaluates correctly in the rows, because there is only one possible value for that field for any value of the dimension; but there are multiple possible values at the partial total level, so the partial total expression cannot be evaluated. For the partial total to evaluate, use an aggregation function such as Max(), Avg(), Sum() etc.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
er_mohit
Master II
Master II

enclosed your expression with sum

sum(your condition)

hope it helps

Not applicable
Author

hi

try

sum(F)

*************

sum(M)

*********************************

or try this

sum( Total F)

*************

sum(Total M)

Not applicable
Author

Hi,

I tried few of those things but still it was not showing the result.

My expression was :

if(citizenship_StdPersonalInfo='Singapore' or isPR_StdPersonalInfo=1, Count({<citizenship_StdPersonalInfo=>}DISTINCT(stdApplicationNo)),0)

And I changed this expression to :

Count({<citizenship_StdPersonalInfo={'Singapore'}> +<isPR_StdPersonalInfo={1}>}DISTINCT(stdApplicationNo))

And I got my output...

But thanks a lot for your inputs

Cheers!!

-Yojas

Not applicable
Author

Hi,

But currently I am showing my total on the top row but I want to show it on the right side of the table means I want horizontal total..

Is there any way to do this in Pivot table??

-Yojas

Not applicable
Author

I have attached a Table image which I was trying to explain for showing horizontal Totals on extreme right of table.

Thanks...

-Yojas

er_mohit
Master II
Master II

click on total column and drag it to horizontal side after last dimension or

another method is

you can use  expression here write Column(1)+Column(2)

hope it helps