Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

peter_bolin
New Contributor II

Table totals

I'm looking for the total value for those in the brackets only (s/b 53). Total should replace the 893. I can't figure out how to do it. Thanks for any help

Thought this would do it, but it didn't.

6 Replies
Employee
Employee

Re: Table totals

One solution would be to use Set Analysis in your expression of Summing or counting your cancels to only show a cancel code of one character.

Sum({$<'Cancel code'={"?"}>}[# of cancels])

Digvijay_Singh
Honored Contributor III

Re: Table totals

May be this -

Sum({$<[Cancel code]={"=len(trim([Cancel Code))>0"}>}[# of cancels])

or may be

Sum(if(len(trim([Cancel Code))>0,[# of cancels]))

peter_bolin
New Contributor II

Re: Table totals

Thanks for the help.

peter_bolin
New Contributor II

Re: Table totals

Thanks for the help

Digvijay_Singh
Honored Contributor III

Re: Table totals

May be [# of Cancels] is your field name. You can check in your fields list and correct if you know how to do it.

peter_bolin
New Contributor II

Re: Table totals

This gets me close. Thanks for your help help! I don't want to take up too much of your time. Thanks again! 

proc freq data=out.success_rate_aphs;

where '27JAN18'D<=aph_date1<'26FEB18'D

    and RB_YES_NO=1;

table CANCEL_CODE /nocol norow nocum nopercent;

run;

Community Browser