Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bartvanwetten
Contributor

Totals within year in pivot table

Hi,

can anybody help me out on this one. The QlikView document is attached.

If I select one year the percentage of the total amount is show correctly. Now if I select two years it should show the percentage still 'within' the year and not, as now, the percentage of the total within the selected two years.

Thanks in advance!

Tags (3)
1 Solution

Accepted Solutions

Re: Totals within year in pivot table

Try this

=Sum( Aantal_per_eenheid)/  sum(total <Periode_Jaar_Only> Aantal_per_eenheid)

3 Replies
vishsaggi
Esteemed Contributor III

Re: Totals within year in pivot table

What is that you are expecting? Can you give your expected values you want to see in your table?

Re: Totals within year in pivot table

Try this

=Sum( Aantal_per_eenheid)/  sum(total <Periode_Jaar_Only> Aantal_per_eenheid)

bartvanwetten
Contributor

Re: Totals within year in pivot table

Sunny,

like charm again. Thx!

Bart