QlikView Pivot Table more Expression Sums

Tue, 19 Jul 2016 17:49:54 GMT

I have calculated the following Pivot Table:

YearMonth	A	B	C	D	E	F
2013-01	12.0%	88.0%	85.8%	85.1%	84.8%	83.9%
2013-02	7.7%	92.3%	91.2%	89.1%	87.6%	86.3%
2013-03	10.1%	89.9%	88.9%	87.9%	86.7%	85.7%
2013-04	9.9%	90.1%	88.9%	87.7%	87.3%	86.4%
2013-05	9.5%	90.5%	89.4%	89.2%	87.5%	85.6%
2013-06	11.3%	88.7%	87.2%	85.6%	84.7%	79.3%
2013-07	10.5%	89.5%	87.3%	84.4%	81.7%	77.0%
2013-08	6.1%	93.9%	92.9%	91.8%	90.6%	89.4%
2013-09	12.1%	87.9%	86.7%	85.8%	85.2%	83.8%
2013-10	13.4%	86.6%	85.9%	85.5%	84.3%	83.9%
2013-11	5.0%	95.0%	93.9%	92.5%	90.9%	90.5%
2013-12	13.8%	86.2%	84.4%	81.2%	79.6%	77.5%
2014-01	12.0%	88.0%	86.8%	85.9%	85.4%	84.8%
2014-02	6.1%	93.9%	92.9%	91.8%	90.6%	89.4%
2014-03	9.6%	90.4%	89.4%	88.6%	87.2%	85.3%
2014-04	5.6%	94.4%	93.8%	92.7%	91.4%	89.8%
2014-05	10.6%	89.4%	87.2%	85.3%	83.9%	81.7%
2014-06	10.8%	89.2%	87.1%	84.2%	81.6%	78.9%
2014-07	10.6%	89.4%	88.4%	84.5%	81.8%	80.8%
2014-08	12.1%	87.9%	86.7%	85.8%	85.2%	83.8%
2014-09	13.4%	86.6%	85.9%	85.5%	84.3%	83.9%
2014-10	5.0%	95.0%	93.9%	92.5%	90.9%	90.5%
2014-11	3.8%	96.2%	95.9%	94.9%	92.7%	91.8%
2014-12	5.6%	94.4%	93.8%	92.7%	91.4%	82.5%
2015-01	10.6%	89.4%	87.2%	85.3%	83.9%	77.5%
2015-02	10.8%	89.2%	87.1%	84.2%	81.6%	86.5%
2015-03	10.4%	89.6%	87.0%	83.1%	82.0%	80.3%
2015-04	5.7%	94.3%	92.4%	91.1%	89.4%	88.0%
2015-05	8.9%	91.1%	89.1%	86.8%	85.5%	83.9%
2015-06	7.6%	92.4%	90.6%	88.8%	87.8%	85.8%
2015-07	16.8%	83.2%	81.7%	79.9%	78.2%	76.2%
2015-08	15.5%	84.5%	79.8%	75.0%	70.4%	66.1%
2015-09	10.0%	90.0%	88.1%	86.7%	85.5%	83.7%
2015-10	14.8%	85.2%	81.1%	79.5%	77.3%	75.5%
2015-11	9.9%	90.1%	88.6%	86.7%	85.4%
2015-12	18.7%	81.3%	78.5%	76.9%
2016-01	9.1%	90.9%	89.5%
2016-02	8.1%	91.9%
Total	9.7%	90.3%	88.5%	86.7%	85.3%	83.8%

The A-F calculation has condition related to YearMonth,. This is a ongoing report, the C-E has some blanks at the most recent months due to the incomplete of data.

I want to add more total rows to the table base on Year. The table should be somthing like this:

YearMonth	A	B	C	D	E	F
Total 2013	10.0%	90.0%	88.1%	86.7%	85.5%	83.7%
Total 2014	14.8%	85.2%	81.1%	79.5%	77.3%	75.5%
Total 2015	9.9%	90.1%	88.6%	86.7%
Total	9.7%	90.3%	88.5%	86.7%	85.3%	83.8%

For each column, if that year doesn't have complete data, I don't want the result displayed. Eg, Total 2016 is not showed, E-F's Total 2015 is blank.

I don't know if it is possible, or I can only create another Pivot table?

Re: QlikView Pivot Table more Expression Sums

swuehl — Tue, 19 Jul 2016 18:17:52 GMT

You can try something like discussed e.g. here:

Re: Conditional formatting and comparison with the median value in the same pivot table

topic QlikView Pivot Table more Expression Sums in QlikView

QlikView Pivot Table more Expression Sums

Re: QlikView Pivot Table more Expression Sums