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

Why are some total information is not displayed for Chart Properties -> Presentation ->Show partial Sum?

Hi there,

Raw data from the Informix database, I find some of the data of GOS can be displayed, but some data of GOS cannot be displayed.

GOS & ACD formula follow:


GOS:


If(period1 = SLA , sum(acdcalls1_sk) ,

If(period2 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) ,

If(period3 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk),

If(period4 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk),

If(period5 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk),

If(period6 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk),

If(period7 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk),

If(period8 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk),

If(period9 = SLA , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk) + sum(acdcalls9_sk),

)))))))))

ACD1~9:

ACD1=sum(acdcalls1_sk) , ACD2=sum(acdcalls2_sk) , ACD3=sum(acdcalls3_sk) , and so on.

I want to know, why some team or country 's can be displayed  (marked in green), but some team or country can't be display(marked in red)?  Thank you in advance!

1 Solution

Accepted Solutions
Not applicable
Author

Hi ,

Kindly try with the following Exp for GOS

sum(aggr(if(period1=SLA,sum(acdcalls1_sk),

if(period2=SLA,sum(acdcalls1_sk+acdcalls2_sk),

if(period3=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk),

if(period4=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk),

if(period5=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk),

if(period6=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk),

if(period7=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk),

if(period8=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk),

if(period9=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk+acdcalls9_sk),

))))))))),PGU,[Support Country], [Team Name], SLA,split,period1,period2,period3,period4,period5,period6,period7,period8,period9))

Thanks

Saurabh

View solution in original post

8 Replies
its_anandrjs

Try to Put

SLA in 'SLA' single  cots marks like

GOS:


If(period1 = 'SLA' , sum(acdcalls1_sk) ,

If(period2 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) ,

If(period3 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk),

If(period4 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk),

If(period5 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk),

If(period6 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk),

If(period7 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk),

If(period8 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk),

If(period9 = 'SLA' , sum(acdcalls1_sk) + sum(acdcalls2_sk) + sum(acdcalls3_sk) + sum(acdcalls4_sk) + sum(acdcalls5_sk) + sum(acdcalls6_sk) + sum(acdcalls7_sk) + sum(acdcalls8_sk) + sum(acdcalls9_sk),

)))))))))

Not applicable
Author

Hi Chouhan,

Thank you so much for your reply. ☺

But after change, all the total doesn’t display. ☹

Could you please help me find the reason? Thank you in advance!

Kind regards,

BinBing

its_anandrjs

It seems need to check your data can you provide sample data for this.

Not applicable
Author

Hi Chouhan,

Enclosed please find sample data and excel file.

In GOS field, some team or country ‘s total can’t be displays. (marked in red)

By country by team:

Just by team:

Really appreciate your help! ☺

Kind regards,

BinBing

Not applicable
Author

The expression u have written in GOS is incorrect.

Because period1 field don't have SLA data, it contains only numeric values.

Check the conditions u have written.

Not applicable
Author

Hi ,

Kindly try with the following Exp for GOS

sum(aggr(if(period1=SLA,sum(acdcalls1_sk),

if(period2=SLA,sum(acdcalls1_sk+acdcalls2_sk),

if(period3=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk),

if(period4=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk),

if(period5=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk),

if(period6=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk),

if(period7=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk),

if(period8=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk),

if(period9=SLA,sum(acdcalls1_sk+acdcalls2_sk+acdcalls3_sk+acdcalls4_sk+acdcalls5_sk+acdcalls6_sk+acdcalls7_sk+acdcalls8_sk+acdcalls9_sk),

))))))))),PGU,[Support Country], [Team Name], SLA,split,period1,period2,period3,period4,period5,period6,period7,period8,period9))

Thanks

Saurabh

Not applicable
Author

Hi Saurabh,

That's great! Problem solved!

Thank you very much for your help!

Have a great day!

kind regards,

BinBing

Not applicable
Author

Welcome