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

Crosstable per month; But Also want a single result. Can't get it to work

Hi,

I've got a crosstable that shows information per week.

But I also want to add some total values per dimension (but not per week). Please see this screenhot.

The yellow single field should be added.

qv_case.png

I have included the .QVW file that hold the data above and the question;

Could someone help me getting the above result?

Thanks!

1 Solution

Accepted Solutions
bbi_mba_76
Partner
Partner

Hi,

and if you create it as a calculated dimension?

=aggr(distinct SUM({<Kalender.Week=>} [Aantal Uren]),[Medewerker Naam])

View solution in original post

3 Replies
Gysbert_Wassenaar

I'm afraid what you want is not possible. As you may have noticed, Qlikview is not a free-form spreadsheet application like MS-Excel. It is possible to create calculated dimensions for use as total columns, but because your pivot table uses collapsible dimensions such total columns need to be on the leftmost side of the pivot table. Perhaps you should simply create a straight table for those totals instead. You'll have two chart objects instead of one, but the information can be presented far more clearly that way.


talk is cheap, supply exceeds demand
bbi_mba_76
Partner
Partner

Hi,

and if you create it as a calculated dimension?

=aggr(distinct SUM({<Kalender.Week=>} [Aantal Uren]),[Medewerker Naam])

View solution in original post

Not applicable
Author

Sometimes the answer can be so easy

Thanks!