Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (2)
10 Replies
Sokkorn
Honored Contributor

Re: Total is not comming properly in the chart

Hi Yojas,

Use NumSum() instead of Sum()

Regards,

Sokkorn

Not applicable

Re: Total is not comming properly in the chart

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

MVP
MVP

Re: Total is not comming properly in the chart

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
Honored Contributor II

Re: Total is not comming properly in the chart

enclosed your expression with sum

sum(your condition)

hope it helps

Not applicable

Re: Total is not comming properly in the chart

hi

try

sum(F)

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

sum(M)

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

or try this

sum( Total F)

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

sum(Total M)

Not applicable

Re: Total is not comming properly in the chart

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

Re: Total is not comming properly in the chart

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

Re: Total is not comming properly in the chart

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
Honored Contributor II

Re: Total is not comming properly in the chart

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

Community Browser