
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Getting the sum per year and per quater
Good day people of Qlik,
Can you help me how to display the Sum of Per Year and Per Quarter of my Receivables.
Sorry for the long post, please help me in my project. thank you in advance
Year | Quarter | Recievables | |||
2009 | 1 | 1613488.7 | |||
2009 | 2 | 1613488.7 | |||
2009 | 3 | 1613488.7 | |||
2009 | 4 | 1613488.7 | |||
2009 | 1 | 6568081.04 | |||
2009 | 2 | 6568081.04 | |||
2009 | 3 | 6568081.04 | |||
2009 | 4 | 6568081.04 | |||
2009 | 1 | 2033106.82 | |||
2009 | 2 | 2033106.82 | |||
2009 | 3 | 2033106.82 | |||
2009 | 4 | 2033106.82 | |||
2009 | 1 | 4265549.02 | |||
2009 | 2 | 4265549.02 | |||
2009 | 3 | 4265549.02 | |||
2009 | 4 | 4265549.02 | |||
2009 | 1 | 6188425.28 | |||
2009 | 2 | 6188425.28 | |||
2009 | 3 | 6188425.28 | |||
2009 | 4 | 6188425.28 | |||
2009 | 1 | 5100402.12 | |||
2009 | 2 | 5100402.12 | |||
2009 | 3 | 5100402.12 | |||
2009 | 4 | 5100402.12 | |||
2009 | 1 | 9397775.48 | |||
2009 | 2 | 9397775.48 | |||
2009 | 3 | 9397775.48 | |||
2009 | 4 | 9397775.48 | |||
2009 | 1 | 2022300.2 | |||
2009 | 2 | 2022300.2 | |||
2009 | 3 | 2022300.2 | |||
2009 | 4 | 2022300.2 | |||
2009 | 1 | 4289713.68 | |||
2009 | 2 | 4289713.68 | |||
2009 | 3 | 4289713.68 | |||
2009 | 4 | 4289713.68 | |||
2009 | 1 | 30135092.36 | |||
2009 | 2 | 30135092.36 | |||
2009 | 3 | 30135092.36 | |||
2009 | 4 | 30135092.36 | |||
2009 | 1 | 1766343.92 | |||
2009 | 2 | 1766343.92 | |||
2009 | 3 | 1766343.92 | |||
2009 | 4 | 1766343.92 | |||
2009 | 1 | 1997332.44 | |||
2009 | 2 | 1997332.44 | |||
2009 | 3 | 1997332.44 | |||
2009 | 4 | 1997332.44 | |||
2009 | 1 | 1988563.62 | |||
2009 | 2 | 1988563.62 | |||
2009 | 3 | 1988563.62 | |||
2009 | 4 | 1988563.62 | |||
2009 | 1 | 3976300.58 | |||
2009 | 2 | 3976300.58 | |||
2009 | 3 | 3976300.58 | |||
2009 | 4 | 3976300.58 | |||
2009 | 1 | 15015116.7 | |||
2009 | 2 | 15015116.7 | |||
2009 | 3 | 15015116.7 | |||
2009 | 4 | 15015116.7 | |||
2009 | 1 | 1404933.44 | |||
2009 | 2 | 1404933.44 | |||
2009 | 3 | 1404933.44 | |||
2009 | 4 | 1404933.44 | |||
2009 | 1 | 1367139.48 | |||
2009 | 2 | 1367139.48 | |||
2009 | 3 | 1367139.48 | |||
2009 | 4 | 1367139.48 | |||
2009 | 1 | 92458.26 | |||
2009 | 2 | 92458.26 | |||
2009 | 3 | 92458.26 | |||
2009 | 4 | 92458.26 | |||
2009 | 1 | 4606346.86 | |||
2009 | 2 | 4606346.86 | |||
2009 | 3 | 4606346.86 | |||
2009 | 4 | 4606346.86 | |||
2009 | 1 | 14153801.06 | |||
2009 | 2 | 14153801.06 | |||
2009 | 3 | 14153801.06 | |||
2009 | 4 | 14153801.06 | |||
2009 | 1 | 4065627.33 | |||
2009 | 2 | 4065627.33 | |||
2009 | 3 | 4065627.33 | |||
2009 | 4 | 4065627.33 | |||
2009 | 1 | 27015699.9 | |||
2009 | 2 | 27015699.9 | |||
2009 | 3 | 27015699.9 | |||
2009 | 4 | 27015699.9 | |||
2009 | 1 | 9642363 | |||
2009 | 2 | 9642363 | |||
2009 | 3 | 9642363 | |||
2009 | 4 | 9642363 | |||
2009 | 1 | 30584203.6 | |||
2009 | 2 | 30584203.6 | |||
2009 | 3 | 30584203.6 | |||
2009 | 4 | 30584203.6 | |||
2009 | 1 | 3533020.88 | |||
2009 | 2 | 3533020.88 | |||
2009 | 3 | 3533020.88 | |||
2009 | 4 | 3533020.88 | |||
2009 | 1 | 6295223.72 | |||
2009 | 2 | 6295223.72 | |||
2009 | 3 | 6295223.72 | |||
2009 | 4 | 6295223.72 | |||
2009 | 1 | 28818077.62 | |||
2009 | 2 | 28818077.62 | |||
2009 | 3 | 28818077.62 | |||
2009 | 4 | 28818077.62 | |||
2009 | 1 | 3367561.12 | |||
2009 | 2 | 3367561.12 | |||
2009 | 3 | 3367561.12 | |||
2009 | 4 | 3367561.12 | |||
2009 | 1 | 2289425.69 | |||
2009 | 2 | 2289425.69 | |||
2009 | 3 | 2289425.69 | |||
2009 | 4 | 2289425.69 | |||
2009 | 1 | 547995.86 | |||
2009 | 2 | 547995.86 | |||
2009 | 3 | 547995.86 | |||
2009 | 4 | 547995.86 | |||
2009 | 1 | 15768294.98 | |||
2009 | 2 | 15768294.98 | |||
2009 | 3 | 15768294.98 | |||
2009 | 4 | 15768294.98 | |||
2009 | 1 | 461335.6 | |||
2009 | 2 | 461335.6 | |||
2009 | 3 | 461335.6 | |||
2009 | 4 | 461335.6 | |||
2009 | 1 | 2039032.95 | |||
2009 | 2 | 2039032.95 | |||
2009 | 3 | 2039032.95 | |||
2009 | 4 | 2039032.95 | |||
2009 | 1 | 5716091.19 | |||
2009 | 2 | 5716091.19 | |||
2009 | 3 | 5716091.19 | |||
2009 | 4 | 5716091.19 | |||
2009 | 1 | 16449083.41 | |||
2009 | 2 | 16449083.41 | |||
2009 | 3 | 16449083.41 | |||
2009 | 4 | 16449083.41 | |||
2010 | 1 | 1613488.7 | |||
2010 | 2 | 1613488.7 | |||
2010 | 3 | 1613488.7 | |||
2010 | 4 | 1613488.7 | |||
2010 | 1 | 6568081.04 | |||
2010 | 2 | 6568081.04 | |||
2010 | 3 | 6568081.04 | |||
2010 | 4 | 6568081.04 | |||
2010 | 1 | 2033106.82 | |||
2010 | 2 | 2033106.82 | |||
2010 | 3 | 2033106.82 | |||
2010 | 4 | 2033106.82 | |||
2010 | 1 | 4265549.02 | |||
2010 | 2 | 4265549.02 | |||
2010 | 3 | 4265549.02 | |||
2010 | 4 | 4265549.02 | |||
2010 | 1 | 6188425.28 | |||
2010 | 2 | 6188425.28 | |||
2010 | 3 | 6188425.28 | |||
2010 | 4 | 6188425.28 | |||
2010 | 1 | 5100402.12 | |||
2010 | 2 | 5100402.12 | |||
2010 | 3 | 5100402.12 | |||
2010 | 4 | 5100402.12 | |||
2010 | 1 | 9397775.48 | |||
2010 | 2 | 9397775.48 | |||
2010 | 3 | 9397775.48 | |||
2010 | 4 | 9397775.48 | |||
2010 | 1 | 2022300.2 | |||
2010 | 2 | 2022300.2 | |||
2010 | 3 | 2022300.2 | |||
2010 | 4 | 2022300.2 | |||
2010 | 1 | 4289713.68 | |||
2010 | 2 | 4289713.68 | |||
2010 | 3 | 4289713.68 | |||
2010 | 4 | 4289713.68 | |||
2010 | 1 | 30135092.36 | |||
2010 | 2 | 30135092.36 | |||
2010 | 3 | 30135092.36 | |||
2010 | 4 | 30135092.36 | |||
2010 | 1 | 1766343.92 | |||
2010 | 2 | 1766343.92 | |||
2010 | 3 | 1766343.92 | |||
2010 | 4 | 1766343.92 | |||
2010 | 1 | 1997332.44 | |||
2010 | 2 | 1997332.44 | |||
2010 | 3 | 1997332.44 | |||
2010 | 4 | 1997332.44 | |||
2010 | 1 | 1988563.62 | |||
2010 | 2 | 1988563.62 | |||
2010 | 3 | 1988563.62 | |||
2010 | 4 | 1988563.62 | |||
2010 | 1 | 3976300.58 | |||
2010 | 2 | 3976300.58 | |||
2010 | 3 | 3976300.58 | |||
2010 | 4 | 3976300.58 | |||
2010 | 1 | 15015116.7 | |||
2010 | 2 | 15015116.7 | |||
2010 | 3 | 15015116.7 | |||
2010 | 4 | 15015116.7 | |||
2010 | 1 | 1404933.44 | |||
2010 | 2 | 1404933.44 | |||
2010 | 3 | 1404933.44 | |||
2010 | 4 | 1404933.44 | |||
2010 | 1 | 1367139.48 | |||
2010 | 2 | 1367139.48 | |||
2010 | 3 | 1367139.48 | |||
2010 | 4 | 1367139.48 | |||
2010 | 1 | 92458.26 | |||
2010 | 2 | 92458.26 | |||
2010 | 3 | 92458.26 | |||
2010 | 4 | 92458.26 | |||
2010 | 1 | 4606346.86 | |||
2010 | 2 | 4606346.86 | |||
2010 | 3 | 4606346.86 | |||
2010 | 4 | 4606346.86 | |||
2010 | 1 | 14153801.06 | |||
2010 | 2 | 14153801.06 | |||
2010 | 3 | 14153801.06 | |||
2010 | 4 | 14153801.06 | |||
2010 | 1 | 4065627.33 | |||
2010 | 2 | 4065627.33 | |||
2010 | 3 | 4065627.33 | |||
2010 | 4 | 4065627.33 | |||
2010 | 1 | 27015699.9 | |||
2010 | 2 | 27015699.9 | |||
2010 | 3 | 27015699.9 | |||
2010 | 4 | 27015699.9 | |||
2010 | 1 | 9642363 | |||
2010 | 2 | 9642363 | |||
2010 | 3 | 9642363 | |||
2010 | 4 | 9642363 | |||
2010 | 1 | 30584203.6 | |||
2010 | 2 | 30584203.6 | |||
2010 | 3 | 30584203.6 | |||
2010 | 4 | 30584203.6 | |||
2010 | 1 | 3533020.88 | |||
2010 | 2 | 3533020.88 | |||
2010 | 3 | 3533020.88 | |||
2010 | 4 | 3533020.88 | |||
2010 | 1 | 6295223.72 | |||
2010 | 2 | 6295223.72 | |||
2010 | 3 | 6295223.72 | |||
2010 | 4 | 6295223.72 | |||
2010 | 1 | 28818077.62 | |||
2010 | 2 | 28818077.62 | |||
2010 | 3 | 28818077.62 | |||
2010 | 4 | 28818077.62 | |||
2010 | 1 | 3367561.12 | |||
2010 | 2 | 3367561.12 | |||
2010 | 3 | 3367561.12 | |||
2010 | 4 | 3367561.12 | |||
2010 | 1 | 2289425.69 | |||
2010 | 2 | 2289425.69 | |||
2010 | 3 | 2289425.69 | |||
2010 | 4 | 2289425.69 | |||
2010 | 1 | 547995.86 | |||
2010 | 2 | 547995.86 | |||
2010 | 3 | 547995.86 | |||
2010 | 4 | 547995.86 | |||
2010 | 1 | 15768294.98 | |||
2010 | 2 | 15768294.98 | |||
2010 | 3 | 15768294.98 | |||
2010 | 4 | 15768294.98 | |||
2010 | 1 | 461335.6 | |||
2010 | 2 | 461335.6 | |||
2010 | 3 | 461335.6 | |||
2010 | 4 | 461335.6 | |||
2010 | 1 | 2039032.95 | |||
2010 | 2 | 2039032.95 | |||
2010 | 3 | 2039032.95 | |||
2010 | 4 | 2039032.95 | |||
2010 | 1 | 5716091.19 | |||
2010 | 2 | 5716091.19 | |||
2010 | 3 | 5716091.19 | |||
2010 | 4 | 5716091.19 | |||
2010 | 1 | 16449083.41 | |||
2010 | 2 | 16449083.41 | |||
2010 | 3 | 16449083.41 | |||
2010 | 4 | 16449083.41 | |||
2011 | 1 | 1613488.7 | |||
2011 | 2 | 1613488.7 | |||
2011 | 3 | 1613488.7 | |||
2011 | 4 | 1613488.7 | |||
2011 | 1 | 6568081.04 | |||
2011 | 2 | 6568081.04 | |||
2011 | 3 | 6568081.04 | |||
2011 | 4 | 6568081.04 | |||
2011 | 1 | 2033106.82 | |||
2011 | 2 | 2033106.82 | |||
2011 | 3 | 2033106.82 | |||
2011 | 4 | 2033106.82 | |||
2011 | 1 | 4265549.02 | |||
2011 | 2 | 4265549.02 | |||
2011 | 3 | 4265549.02 | |||
2011 | 4 | 4265549.02 | |||
2011 | 1 | 6188425.28 | |||
2011 | 2 | 6188425.28 | |||
2011 | 3 | 6188425.28 | |||
2011 | 4 | 6188425.28 | |||
2011 | 1 | 5100402.12 | |||
2011 | 2 | 5100402.12 | |||
2011 | 3 | 5100402.12 | |||
2011 | 4 | 5100402.12 | |||
2011 | 1 | 9397775.48 | |||
2011 | 2 | 9397775.48 | |||
2011 | 3 | 9397775.48 | |||
2011 | 4 | 9397775.48 | |||
2011 | 1 | 2022300.2 | |||
2011 | 2 | 2022300.2 | |||
2011 | 3 | 2022300.2 | |||
2011 | 4 | 2022300.2 | |||
2011 | 1 | 4289713.68 | |||
2011 | 2 | 4289713.68 | |||
2011 | 3 | 4289713.68 | |||
2011 | 4 | 4289713.68 | |||
2011 | 1 | 30135092.36 | |||
2011 | 2 | 30135092.36 | |||
2011 | 3 | 30135092.36 | |||
2011 | 4 | 30135092.36 | |||
2011 | 1 | 1766343.92 | |||
2011 | 2 | 1766343.92 | |||
2011 | 3 | 1766343.92 | |||
2011 | 4 | 1766343.92 | |||
2011 | 1 | 1997332.44 | |||
2011 | 2 | 1997332.44 | |||
2011 | 3 | 1997332.44 | |||
2011 | 4 | 1997332.44 | |||
2011 | 1 | 1988563.62 | |||
2011 | 2 | 1988563.62 | |||
2011 | 3 | 1988563.62 | |||
2011 | 4 | 1988563.62 | |||
2011 | 1 | 3976300.58 | |||
2011 | 2 | 3976300.58 | |||
2011 | 3 | 3976300.58 | |||
2011 | 4 | 3976300.58 | |||
2011 | 1 | 15015116.7 | |||
2011 | 2 | 15015116.7 | |||
2011 | 3 | 15015116.7 | |||
2011 | 4 | 15015116.7 | |||
2011 | 1 | 1404933.44 | |||
2011 | 2 | 1404933.44 | |||
2011 | 3 | 1404933.44 | |||
2011 | 4 | 1404933.44 | |||
2011 | 1 | 1367139.48 | |||
2011 | 2 | 1367139.48 | |||
2011 | 3 | 1367139.48 | |||
2011 | 4 | 1367139.48 | |||
2011 | 1 | 92458.26 | |||
2011 | 2 | 92458.26 | |||
2011 | 3 | 92458.26 | |||
2011 | 4 | 92458.26 | |||
2011 | 1 | 4606346.86 | |||
2011 | 2 | 4606346.86 | |||
2011 | 3 | 4606346.86 | |||
2011 | 4 | 4606346.86 | |||
2011 | 1 | 14153801.06 | |||
2011 | 2 | 14153801.06 | |||
2011 | 3 | 14153801.06 | |||
2011 | 4 | 14153801.06 | |||
2011 | 1 | 4065627.33 | |||
2011 | 2 | 4065627.33 | |||
2011 | 3 | 4065627.33 | |||
2011 | 4 | 4065627.33 | |||
2011 | 1 | 27015699.9 | |||
2011 | 2 | 27015699.9 | |||
2011 | 3 | 27015699.9 | |||
2011 | 4 | 27015699.9 | |||
2011 | 1 | 9642363 | |||
2011 | 2 | 9642363 | |||
2011 | 3 | 9642363 | |||
2011 | 4 | 9642363 | |||
2011 | 1 | 30584203.6 | |||
2011 | 2 | 30584203.6 | |||
2011 | 3 | 30584203.6 | |||
2011 | 4 | 30584203.6 | |||
2011 | 1 | 3533020.88 | |||
2011 | 2 | 3533020.88 | |||
2011 | 3 | 3533020.88 | |||
2011 | 4 | 3533020.88 | |||
2011 | 1 | 6295223.72 | |||
2011 | 2 | 6295223.72 | |||
2011 | 3 | 6295223.72 | |||
2011 | 4 | 6295223.72 | |||
2011 | 1 | 28818077.62 | |||
2011 | 2 | 28818077.62 | |||
2011 | 3 | 28818077.62 | |||
2011 | 4 | 28818077.62 | |||
2011 | 1 | 3367561.12 | |||
2011 | 2 | 3367561.12 | |||
2011 | 3 | 3367561.12 | |||
2011 | 4 | 3367561.12 | |||
2011 | 1 | 2289425.69 | |||
2011 | 2 | 2289425.69 | |||
2011 | 3 | 2289425.69 | |||
2011 | 4 | 2289425.69 | |||
2011 | 1 | 547995.86 | |||
2011 | 2 | 547995.86 | |||
2011 | 3 | 547995.86 | |||
2011 | 4 | 547995.86 | |||
2011 | 1 | 15768294.98 | |||
2011 | 2 | 15768294.98 | |||
2011 | 3 | 15768294.98 | |||
2011 | 4 | 15768294.98 | |||
2011 | 1 | 461335.6 | |||
2011 | 2 | 461335.6 | |||
2011 | 3 | 461335.6 | |||
2011 | 4 | 461335.6 | |||
2011 | 1 | 2039032.95 | |||
2011 | 2 | 2039032.95 | |||
2011 | 3 | 2039032.95 | |||
2011 | 4 | 2039032.95 | |||
2011 | 1 | 5716091.19 | |||
2011 | 2 | 5716091.19 | |||
2011 | 3 | 5716091.19 | |||
2011 | 4 | 5716091.19 | |||
2011 | 1 | 16449083.41 | |||
2011 | 2 | 16449083.41 | |||
2011 | 3 | 16449083.41 | |||
2011 | 4 | 16449083.41 | |||
2012 | 1 | 1613488.7 | |||
2012 | 2 | 1613488.7 | |||
2012 | 3 | 1613488.7 | |||
2012 | 4 | 1613488.7 | |||
2012 | 1 | 6568081.04 | |||
2012 | 2 | 6568081.04 | |||
2012 | 3 | 6568081.04 | |||
2012 | 4 | 6568081.04 | |||
2012 | 1 | 2033106.82 | |||
2012 | 2 | 2033106.82 | |||
2012 | 3 | 2033106.82 | |||
2012 | 4 | 2033106.82 | |||
2012 | 1 | 4265549.02 | |||
2012 | 2 | 4265549.02 | |||
2012 | 3 | 4265549.02 | |||
2012 | 4 | 4265549.02 | |||
2012 | 1 | 6188425.28 | |||
2012 | 2 | 6188425.28 | |||
2012 | 3 | 6188425.28 | |||
2012 | 4 | 6188425.28 | |||
2012 | 1 | 5100402.12 | |||
2012 | 2 | 5100402.12 | |||
2012 | 3 | 5100402.12 | |||
2012 | 4 | 5100402.12 | |||
2012 | 1 | 9397775.48 | |||
2012 | 2 | 9397775.48 | |||
2012 | 3 | 9397775.48 | |||
2012 | 4 | 9397775.48 | |||
2012 | 1 | 2022300.2 | |||
2012 | 2 | 2022300.2 | |||
2012 | 3 | 2022300.2 | |||
2012 | 4 | 2022300.2 | |||
2012 | 1 | 4289713.68 | |||
2012 | 2 | 4289713.68 | |||
2012 | 3 | 4289713.68 | |||
2012 | 4 | 4289713.68 | |||
2012 | 1 | 30135092.36 | |||
2012 | 2 | 30135092.36 | |||
2012 | 3 | 30135092.36 | |||
2012 | 4 | 30135092.36 | |||
2012 | 1 | 1766343.92 | |||
2012 | 2 | 1766343.92 | |||
2012 | 3 | 1766343.92 | |||
2012 | 4 | 1766343.92 | |||
2012 | 1 | 1997332.44 | |||
2012 | 2 | 1997332.44 | |||
2012 | 3 | 1997332.44 | |||
2012 | 4 | 1997332.44 | |||
2012 | 1 | 1988563.62 | |||
2012 | 2 | 1988563.62 | |||
2012 | 3 | 1988563.62 | |||
2012 | 4 | 1988563.62 | |||
2012 | 1 | 3976300.58 | |||
2012 | 2 | 3976300.58 | |||
2012 | 3 | 3976300.58 | |||
2012 | 4 | 3976300.58 | |||
2012 | 1 | 15015116.7 | |||
2012 | 2 | 15015116.7 | |||
2012 | 3 | 15015116.7 | |||
2012 | 4 | 15015116.7 | |||
2012 | 1 | 1404933.44 | |||
2012 | 2 | 1404933.44 | |||
2012 | 3 | 1404933.44 | |||
2012 | 4 | 1404933.44 | |||
2012 | 1 | 1367139.48 | |||
2012 | 2 | 1367139.48 | |||
2012 | 3 | 1367139.48 | |||
2012 | 4 | 1367139.48 | |||
2012 | 1 | 92458.26 | |||
2012 | 2 | 92458.26 | |||
2012 | 3 | 92458.26 | |||
2012 | 4 | 92458.26 | |||
2012 | 1 | 4606346.86 | |||
2012 | 2 | 4606346.86 | |||
2012 | 3 | 4606346.86 | |||
2012 | 4 | 4606346.86 | |||
2012 | 1 | 14153801.06 | |||
2012 | 2 | 14153801.06 | |||
2012 | 3 | 14153801.06 | |||
2012 | 4 | 14153801.06 | |||
2012 | 1 | 4065627.33 | |||
2012 | 2 | 4065627.33 | |||
2012 | 3 | 4065627.33 | |||
2012 | 4 | 4065627.33 | |||
2012 | 1 | 27015699.9 | |||
2012 | 2 | 27015699.9 | |||
2012 | 3 | 27015699.9 | |||
2012 | 4 | 27015699.9 | |||
2012 | 1 | 9642363 | |||
2012 | 2 | 9642363 | |||
2012 | 3 | 9642363 | |||
2012 | 4 | 9642363 | |||
2012 | 1 | 30584203.6 | |||
2012 | 2 | 30584203.6 | |||
2012 | 3 | 30584203.6 | |||
2012 | 4 | 30584203.6 | |||
2012 | 1 | 3533020.88 | |||
2012 | 2 | 3533020.88 | |||
2012 | 3 | 3533020.88 | |||
2012 | 4 | 3533020.88 | |||
2012 | 1 | 6295223.72 | |||
2012 | 2 | 6295223.72 | |||
2012 | 3 | 6295223.72 | |||
2012 | 4 | 6295223.72 | |||
2012 | 1 | 28818077.62 | |||
2012 | 2 | 28818077.62 | |||
2012 | 3 | 28818077.62 | |||
2012 | 4 | 28818077.62 | |||
2012 | 1 | 3367561.12 | |||
2012 | 2 | 3367561.12 | |||
2012 | 3 | 3367561.12 | |||
2012 | 4 | 3367561.12 | |||
2012 | 1 | 2289425.69 | |||
2012 | 2 | 2289425.69 | |||
2012 | 3 | 2289425.69 | |||
2012 | 4 | 2289425.69 | |||
2012 | 1 | 547995.86 | |||
2012 | 2 | 547995.86 | |||
2012 | 3 | 547995.86 | |||
2012 | 4 | 547995.86 | |||
2012 | 1 | 15768294.98 | |||
2012 | 2 | 15768294.98 | |||
2012 | 3 | 15768294.98 | |||
2012 | 4 | 15768294.98 | |||
2012 | 1 | 461335.6 | |||
2012 | 2 | 461335.6 | |||
2012 | 3 | 461335.6 | |||
2012 | 4 | 461335.6 | |||
2012 | 1 | 2039032.95 | |||
2012 | 2 | 2039032.95 | |||
2012 | 3 | 2039032.95 | |||
2012 | 4 | 2039032.95 | |||
2012 | 1 | 5716091.19 | |||
2012 | 2 | 5716091.19 | |||
2012 | 3 | 5716091.19 | |||
2012 | 4 | 5716091.19 | |||
2012 | 1 | 16449083.41 | |||
2012 | 2 | 16449083.41 | |||
2012 | 3 | 16449083.41 | |||
2012 | 4 | 16449083.41 | |||
2013 | 4 | 1613488.7 | |||
2013 | 3 | 1613488.7 | |||
2013 | 2 | 1613488.7 | |||
2013 | 1 | 1613488.7 | |||
2013 | 4 | 6568081.04 | |||
2013 | 3 | 6568081.04 | |||
2013 | 2 | 6568081.04 | |||
2013 | 1 | 6568081.04 | |||
2013 | 4 | 2033106.82 | |||
2013 | 3 | 2033106.82 | |||
2013 | 2 | 2033106.82 | |||
2013 | 1 | 2033106.82 | |||
2013 | 4 | 4265549.02 | |||
2013 | 3 | 4265549.02 | |||
2013 | 2 | 4265549.02 | |||
2013 | 1 | 4265549.02 | |||
2013 | 4 | 6188425.28 | |||
2013 | 3 | 6188425.28 | |||
2013 | 2 | 6188425.28 | |||
2013 | 1 | 6188425.28 | |||
2013 | 4 | 5100402.12 | |||
2013 | 3 | 5100402.12 | |||
2013 | 2 | 5100402.12 | |||
2013 | 1 | 5100402.12 | |||
2013 | 4 | 9397775.48 | |||
2013 | 3 | 9397775.48 | |||
2013 | 2 | 9397775.48 | |||
2013 | 1 | 9397775.48 | |||
2013 | 4 | 2022300.2 | |||
2013 | 3 | 2022300.2 | |||
2013 | 2 | 2022300.2 | |||
2013 | 1 | 2022300.2 | |||
2013 | 4 | 4289713.68 | |||
2013 | 3 | 4289713.68 | |||
2013 | 2 | 4289713.68 | |||
2013 | 1 | 4289713.68 | |||
2013 | 4 | 30135092.36 | |||
2013 | 3 | 30135092.36 | |||
2013 | 2 | 30135092.36 | |||
2013 | 1 | 30135092.36 | |||
2013 | 4 | 1766343.92 | |||
2013 | 3 | 1766343.92 | |||
2013 | 2 | 1766343.92 | |||
2013 | 1 | 1766343.92 | |||
2013 | 4 | 1997332.44 | |||
2013 | 3 | 1997332.44 | |||
2013 | 2 | 1997332.44 | |||
2013 | 1 | 1997332.44 | |||
2013 | 4 | 1988563.62 | |||
2013 | 3 | 1988563.62 | |||
2013 | 2 | 1988563.62 | |||
2013 | 1 | 1988563.62 | |||
2013 | 4 | 3976300.58 | |||
2013 | 3 | 3976300.58 | |||
2013 | 2 | 3976300.58 | |||
2013 | 1 | 3976300.58 | |||
2013 | 4 | 15015116.7 | |||
2013 | 3 | 15015116.7 | |||
2013 | 2 | 15015116.7 | |||
2013 | 1 | 15015116.7 | |||
2013 | 4 | 1404933.44 | |||
2013 | 3 | 1404933.44 | |||
2013 | 2 | 1404933.44 | |||
2013 | 1 | 1404933.44 | |||
2013 | 4 | 1367139.48 | |||
2013 | 3 | 1367139.48 | |||
2013 | 2 | 1367139.48 | |||
2013 | 1 | 1367139.48 | |||
2013 | 4 | 92458.26 | |||
2013 | 3 | 92458.26 | |||
2013 | 2 | 92458.26 | |||
2013 | 1 | 92458.26 | |||
2013 | 4 | 4606346.86 | |||
2013 | 3 | 4606346.86 | |||
2013 | 2 | 4606346.86 | |||
2013 | 1 | 4606346.86 | |||
2013 | 4 | 14153801.06 | |||
2013 | 3 | 14153801.06 | |||
2013 | 2 | 14153801.06 | |||
2013 | 1 | 14153801.06 | |||
2013 | 4 | 4065627.33 | |||
2013 | 3 | 4065627.33 | |||
2013 | 2 | 4065627.33 | |||
2013 | 1 | 4065627.33 | |||
2013 | 4 | 27015699.9 | |||
2013 | 3 | 27015699.9 | |||
2013 | 2 | 27015699.9 | |||
2013 | 1 | 27015699.9 | |||
2013 | 4 | 9642363 | |||
2013 | 3 | 9642363 | |||
2013 | 2 | 9642363 | |||
2013 | 1 | 9642363 | |||
2013 | 4 | 30584203.6 | |||
2013 | 3 | 30584203.6 | |||
2013 | 2 | 30584203.6 | |||
2013 | 1 | 30584203.6 | |||
2013 | 4 | 3533020.88 | |||
2013 | 3 | 3533020.88 | |||
2013 | 2 | 3533020.88 | |||
2013 | 1 | 3533020.88 | |||
2013 | 4 | 6295223.72 | |||
2013 | 3 | 6295223.72 | |||
2013 | 2 | 6295223.72 | |||
2013 | 1 | 6295223.72 | |||
2013 | 4 | 28818077.62 | |||
2013 | 3 | 28818077.62 | |||
2013 | 2 | 28818077.62 | |||
2013 | 1 | 28818077.62 | |||
2013 | 4 | 3367561.12 | |||
2013 | 3 | 3367561.12 | |||
2013 | 2 | 3367561.12 | |||
2013 | 1 | 3367561.12 | |||
2013 | 4 | 2289425.69 | |||
2013 | 3 | 2289425.69 | |||
2013 | 2 | 2289425.69 | |||
2013 | 1 | 2289425.69 | |||
2013 | 4 | 547995.86 | |||
2013 | 3 | 547995.86 | |||
2013 | 2 | 547995.86 | |||
2013 | 1 | 547995.86 | |||
2013 | 4 | 15768294.98 | |||
2013 | 3 | 15768294.98 | |||
2013 | 2 | 15768294.98 | |||
2013 | 1 | 15768294.98 | |||
2013 | 4 | 461335.6 | |||
2013 | 3 | 461335.6 | |||
2013 | 2 | 461335.6 | |||
2013 | 1 | 461335.6 | |||
2013 | 4 | 2039032.95 | |||
2013 | 3 | 2039032.95 | |||
2013 | 2 | 2039032.95 | |||
2013 | 1 | 2039032.95 | |||
2013 | 4 | 5716091.19 | |||
2013 | 3 | 5716091.19 | |||
2013 | 2 | 5716091.19 | |||
2013 | 1 | 5716091.19 | |||
2013 | 4 | 16449083.41 | |||
2013 | 3 | 16449083.41 | |||
2013 | 2 | 16449083.41 | |||
2013 | 1 | 16449083.41 | |||
2014 | 4 | 1613488.7 | |||
2014 | 3 | 1613488.7 | |||
2014 | 2 | 1613488.7 | |||
2014 | 1 | 1613488.7 | |||
2014 | 4 | 6568081.04 | |||
2014 | 3 | 6568081.04 | |||
2014 | 2 | 6568081.04 | |||
2014 | 1 | 6568081.04 | |||
2014 | 4 | 2033106.82 | |||
2014 | 3 | 2033106.82 | |||
2014 | 2 | 2033106.82 | |||
2014 | 1 | 2033106.82 | |||
2014 | 4 | 4265549.02 | |||
2014 | 3 | 4265549.02 | |||
2014 | 2 | 4265549.02 | |||
2014 | 1 | 4265549.02 | |||
2014 | 4 | 6188425.28 | |||
2014 | 3 | 6188425.28 | |||
2014 | 2 | 6188425.28 | |||
2014 | 1 | 6188425.28 | |||
2014 | 4 | 5100402.12 | |||
2014 | 3 | 5100402.12 | |||
2014 | 2 | 5100402.12 | |||
2014 | 1 | 5100402.12 | |||
2014 | 4 | 9397775.48 | |||
2014 | 3 | 9397775.48 | |||
2014 | 2 | 9397775.48 | |||
2014 | 1 | 9397775.48 | |||
2014 | 4 | 2022300.2 | |||
2014 | 3 | 2022300.2 | |||
2014 | 2 | 2022300.2 | |||
2014 | 1 | 2022300.2 | |||
2014 | 4 | 4289713.68 | |||
2014 | 3 | 4289713.68 | |||
2014 | 2 | 4289713.68 | |||
2014 | 1 | 4289713.68 | |||
2014 | 4 | 30135092.36 | |||
2014 | 3 | 30135092.36 | |||
2014 | 2 | 30135092.36 | |||
2014 | 1 | 30135092.36 | |||
2014 | 4 | 1766343.92 | |||
2014 | 3 | 1766343.92 | |||
2014 | 2 | 1766343.92 | |||
2014 | 1 | 1766343.92 | |||
2014 | 4 | 1997332.44 | |||
2014 | 3 | 1997332.44 | |||
2014 | 2 | 1997332.44 | |||
2014 | 1 | 1997332.44 | |||
2014 | 4 | 1988563.62 | |||
2014 | 3 | 1988563.62 | |||
2014 | 2 | 1988563.62 | |||
2014 | 1 | 1988563.62 | |||
2014 | 4 | 3976300.58 | |||
2014 | 3 | 3976300.58 | |||
2014 | 2 | 3976300.58 | |||
2014 | 1 | 3976300.58 | |||
2014 | 4 | 15015116.7 | |||
2014 | 3 | 15015116.7 | |||
2014 | 2 | 15015116.7 | |||
2014 | 1 | 15015116.7 | |||
2014 | 4 | 1404933.44 | |||
2014 | 3 | 1404933.44 | |||
2014 | 2 | 1404933.44 | |||
2014 | 1 | 1404933.44 | |||
2014 | 4 | 1367139.48 | |||
2014 | 3 | 1367139.48 | |||
2014 | 2 | 1367139.48 | |||
2014 | 1 | 1367139.48 | |||
2014 | 4 | 92458.26 | |||
2014 | 3 | 92458.26 | |||
2014 | 2 | 92458.26 | |||
2014 | 1 | 92458.26 | |||
2014 | 4 | 4606346.86 | |||
2014 | 3 | 4606346.86 | |||
2014 | 2 | 4606346.86 | |||
2014 | 1 | 4606346.86 | |||
2014 | 4 | 14153801.06 | |||
2014 | 3 | 14153801.06 | |||
2014 | 2 | 14153801.06 | |||
2014 | 1 | 14153801.06 | |||
2014 | 4 | 4065627.33 | |||
2014 | 3 | 4065627.33 | |||
2014 | 2 | 4065627.33 | |||
2014 | 1 | 4065627.33 | |||
2014 | 4 | 27015699.9 | |||
2014 | 3 | 27015699.9 | |||
2014 | 2 | 27015699.9 | |||
2014 | 1 | 27015699.9 | |||
2014 | 4 | 9642363 | |||
2014 | 3 | 9642363 | |||
2014 | 2 | 9642363 | |||
2014 | 1 | 9642363 | |||
2014 | 4 | 30584203.6 | |||
2014 | 3 | 30584203.6 | |||
2014 | 2 | 30584203.6 | |||
2014 | 1 | 30584203.6 | |||
2014 | 4 | 3533020.88 | |||
2014 | 3 | 3533020.88 | |||
2014 | 2 | 3533020.88 | |||
2014 | 1 | 3533020.88 | |||
2014 | 4 | 6295223.72 | |||
2014 | 3 | 6295223.72 | |||
2014 | 2 | 6295223.72 | |||
2014 | 1 | 6295223.72 | |||
2014 | 4 | 28818077.62 | |||
2014 | 3 | 28818077.62 | |||
2014 | 2 | 28818077.62 | |||
2014 | 1 | 28818077.62 | |||
2014 | 4 | 3367561.12 | |||
2014 | 3 | 3367561.12 | |||
2014 | 2 | 3367561.12 | |||
2014 | 1 | 3367561.12 | |||
2014 | 4 | 2289425.69 | |||
2014 | 3 | 2289425.69 | |||
2014 | 2 | 2289425.69 | |||
2014 | 1 | 2289425.69 | |||
2014 | 4 | 547995.86 | |||
2014 | 3 | 547995.86 | |||
2014 | 2 | 547995.86 | |||
2014 | 1 | 547995.86 | |||
2014 | 4 | 15768294.98 | |||
2014 | 3 | 15768294.98 | |||
2014 | 2 | 15768294.98 | |||
2014 | 1 | 15768294.98 | |||
2014 | 4 | 461335.6 | |||
2014 | 3 | 461335.6 | |||
2014 | 2 | 461335.6 | |||
2014 | 1 | 461335.6 | |||
2014 | 4 | 2039032.95 | |||
2014 | 3 | 2039032.95 | |||
2014 | 2 | 2039032.95 | |||
2014 | 1 | 2039032.95 | |||
2014 | 4 | 5716091.19 | |||
2014 | 3 | 5716091.19 | |||
2014 | 2 | 5716091.19 | |||
2014 | 1 | 5716091.19 | |||
2014 | 4 | 16449083.41 | |||
2014 | 3 | 16449083.41 | |||
2014 | 2 | 16449083.41 | |||
2014 | 1 | 16449083.41 | |||
2015 | 4 | 1613488.7 | |||
2015 | 3 | 1613488.7 | |||
2015 | 1 | 1613488.7 | |||
2015 | 2 | 1613488.7 | |||
2015 | 4 | 6568081.04 | |||
2015 | 3 | 6568081.04 | |||
2015 | 1 | 6568081.04 | |||
2015 | 2 | 6568081.04 | |||
2015 | 4 | 2033106.82 | |||
2015 | 3 | 2033106.82 | |||
2015 | 1 | 2033106.82 | |||
2015 | 2 | 2033106.82 | |||
2015 | 4 | 4265549.02 | |||
2015 | 3 | 4265549.02 | |||
2015 | 1 | 4265549.02 | |||
2015 | 2 | 4265549.02 | |||
2015 | 4 | 6188425.28 | |||
2015 | 3 | 6188425.28 | |||
2015 | 1 | 6188425.28 | |||
2015 | 2 | 6188425.28 | |||
2015 | 4 | 5100402.12 | |||
2015 | 3 | 5100402.12 | |||
2015 | 1 | 5100402.12 | |||
2015 | 2 | 5100402.12 | |||
2015 | 4 | 9397775.48 | |||
2015 | 3 | 9397775.48 | |||
2015 | 1 | 9397775.48 | |||
2015 | 2 | 9397775.48 | |||
2015 | 4 | 2022300.2 | |||
2015 | 3 | 2022300.2 | |||
2015 | 1 | 2022300.2 | |||
2015 | 2 | 2022300.2 | |||
2015 | 4 | 4289713.68 | |||
2015 | 3 | 4289713.68 | |||
2015 | 1 | 4289713.68 | |||
2015 | 2 | 4289713.68 | |||
2015 | 4 | 30135092.36 | |||
2015 | 3 | 30135092.36 | |||
2015 | 1 | 30135092.36 | |||
2015 | 2 | 30135092.36 | |||
2015 | 4 | 1766343.92 | |||
2015 | 3 | 1766343.92 | |||
2015 | 1 | 1766343.92 | |||
2015 | 2 | 1766343.92 | |||
2015 | 4 | 1997332.44 | |||
2015 | 3 | 1997332.44 | |||
2015 | 1 | 1997332.44 | |||
2015 | 2 | 1997332.44 | |||
2015 | 4 | 1988563.62 | |||
2015 | 3 | 1988563.62 | |||
2015 | 1 | 1988563.62 | |||
2015 | 2 | 1988563.62 | |||
2015 | 4 | 3976300.58 | |||
2015 | 3 | 3976300.58 | |||
2015 | 1 | 3976300.58 | |||
2015 | 2 | 3976300.58 | |||
2015 | 4 | 15015116.7 | |||
2015 | 3 | 15015116.7 | |||
2015 | 1 | 15015116.7 | |||
2015 | 2 | 15015116.7 | |||
2015 | 4 | 1404933.44 | |||
2015 | 3 | 1404933.44 | |||
2015 | 1 | 1404933.44 | |||
2015 | 2 | 1404933.44 | |||
2015 | 4 | 1367139.48 | |||
2015 | 3 | 1367139.48 | |||
2015 | 1 | 1367139.48 | |||
2015 | 2 | 1367139.48 | |||
2015 | 4 | 92458.26 | |||
2015 | 3 | 92458.26 | |||
2015 | 1 | 92458.26 | |||
2015 | 2 | 92458.26 | |||
2015 | 4 | 4606346.86 | |||
2015 | 3 | 4606346.86 | |||
2015 | 1 | 4606346.86 | |||
2015 | 2 | 4606346.86 | |||
2015 | 4 | 14153801.06 | |||
2015 | 3 | 14153801.06 | |||
2015 | 1 | 14153801.06 | |||
2015 | 2 | 14153801.06 | |||
2015 | 4 | 4065627.33 | |||
2015 | 3 | 4065627.33 | |||
2015 | 1 | 4065627.33 | |||
2015 | 2 | 4065627.33 | |||
2015 | 4 | 27015699.9 | |||
2015 | 3 | 27015699.9 | |||
2015 | 1 | 27015699.9 | |||
2015 | 2 | 27015699.9 | |||
2015 | 4 | 9642363 | |||
2015 | 3 | 9642363 | |||
2015 | 1 | 9642363 | |||
2015 | 2 | 9642363 | |||
2015 | 4 | 30584203.6 | |||
2015 | 3 | 30584203.6 | |||
2015 | 1 | 30584203.6 | |||
2015 | 2 | 30584203.6 | |||
2015 | 4 | 3533020.88 | |||
2015 | 3 | 3533020.88 | |||
2015 | 1 | 3533020.88 | |||
2015 | 2 | 3533020.88 | |||
2015 | 4 | 6295223.72 | |||
2015 | 3 | 6295223.72 | |||
2015 | 1 | 6295223.72 | |||
2015 | 2 | 6295223.72 | |||
2015 | 4 | 28818077.62 | |||
2015 | 3 | 28818077.62 | |||
2015 | 1 | 28818077.62 | |||
2015 | 2 | 28818077.62 | |||
2015 | 4 | 3367561.12 | |||
2015 | 3 | 3367561.12 | |||
2015 | 1 | 3367561.12 | |||
2015 | 2 | 3367561.12 | |||
2015 | 4 | 2289425.69 | |||
2015 | 3 | 2289425.69 | |||
2015 | 1 | 2289425.69 | |||
2015 | 2 | 2289425.69 | |||
2015 | 4 | 547995.86 | |||
2015 | 3 | 547995.86 | |||
2015 | 1 | 547995.86 | |||
2015 | 2 | 547995.86 | |||
2015 | 4 | 15768294.98 | |||
2015 | 3 | 15768294.98 | |||
2015 | 1 | 15768294.98 | |||
2015 | 2 | 15768294.98 | |||
2015 | 4 | 461335.6 | |||
2015 | 3 | 461335.6 | |||
2015 | 1 | 461335.6 | |||
2015 | 2 | 461335.6 | |||
2015 | 4 | 2039032.95 | |||
2015 | 3 | 2039032.95 | |||
2015 | 1 | 2039032.95 | |||
2015 | 2 | 2039032.95 | |||
2015 | 4 | 5716091.19 | |||
2015 | 3 | 5716091.19 | |||
2015 | 1 | 5716091.19 | |||
2015 | 2 | 5716091.19 | |||
2015 | 4 | 16449083.41 | |||
2015 | 3 | 16449083.41 | |||
2015 | 1 | 16449083.41 | |||
2015 | 2 | 16449083.41 |
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make a Pivot table.
Be sure to turn on "Show Partial Sum" (found on the presentation tab) for Quarter; this will give you the total per year. The default expression result will be your sum per quarter.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sir on the Pivot table it only show the sum of 1 quarter for the whole year.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This s not a pivot table. this is a straight table.
You can do the following:
Create a Pivot Table
First Dim: Year
Second: Quarter
Expression: sum(Receivables)
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Without viewing the actual expressions, I can not see why they are not equal and can only assume that you are not using the same expressions and dimensions.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find attached QVW & let me know if you are looking for the same solution.
--
Regards,
Prashant P Baste


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
HI Lester,
can you upload your qvw for investigation?
Andy
