Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fcecconi
Partner
Partner

Help with totals in a straight table

I need a little help.  I am trying to get a sum of pubs by a publication for a set of years, then get the % of pubs per for the overall total

YearPublicaionYear PubsTotals PubsYear %

2000

Times5
2001Times8
2002Times9
2003Times6
2004Times15
2005Times18
2006Times7

I am able to get the total pubs, but somtimes the total value for a given pub is not showing on every line. So each line should show 68 for the total amount of pubs.  The year % for 2000 should be 5 / 68, 2001 should be 8 /68 and so on.

thanks for your assistance.

1 Solution

Accepted Solutions
Not applicable

Hi Frank,

Have a look at the attached, think that is what you are after

hope that helps

Joe

View solution in original post

5 Replies
delmak2000
Creator
Creator

Hi, Frank!

what chart type are you using? Is it a Pivot? or a Straight table?

Since you are able to get the total sums of pubs but not showing for every line seems you might not have expanded the pivot chart which i suspect u must be using? Then to have extra column u could create an expression using Sum(Amount of Pubs)/Sum(Total (Amount of Pubs)) and using the percentage check field in the number settings....

You might need to attach a sample file to enable forum users understand exactly what the challenge is....

I hope that helps....or sheds some light

Cheers

Ayodele

Not applicable

Hi Frank,

Have a look at the attached, think that is what you are after

hope that helps

Joe

View solution in original post

fcecconi
Partner
Partner
Author

Joe

thanks.  In your example I need to replace the [Year Pub] with a count( distinct id)

fcecconi
Partner
Partner
Author

Joe

I changed to use the following:

Sum

(Total <Publicatopm>aggr(Count(DISTINCT ID),Publication))

and worked like a charm.. THanks for you yelp!


fcecconi
Partner
Partner
Author

Joe

If I have multiple years in the chart and want a ranking by publication by year, how can I do that?

thanks