topic Re: Problem with "Show Partial Sums" in QlikView

Problem with "Show Partial Sums"

Tue, 17 Dec 2013 23:03:12 GMT

I have the following table in QlikView

When I select "Show Partial Sum" the bottom row is giving the right results but the right column is not working property.

The expressions are calculated with this formula count({<event_date={">=$(=date(today() - 7))"} >} distinct element)

I am assuming that QlikView is having some issues with the count and the distinct and it is not displaying the right result on the total.

Can someone help?

Re: Problem with "Show Partial Sums"

jagan — Wed, 18 Dec 2013 02:17:11 GMT

Hi Marco,

When using the Distinct Count not show sum of all values, because Pivot table uses Expression total, i.e., it gets the overall Distinct count irrespective of Dimensions, where as for dimension values it is calculated at Dimension level. If you want both values same then convert this chart to Straight table and select Sum of Rows option in Expressions tab.

For example

Year ID

2012 1

2012 2

2013 2

When you get the count by Year level you will get Distinct ID for 2012 as and 2013 as 1 (2 + 1 = 3) and if you get overall then the distinct count is 2.

If you want to override this then use the following expression

=If(RowNo() = 0, Sum(Aggr(count({<event_date={">=$(=date(today() - 7))"} >} distinct element), ADSource, Color, month, Day)), count({<event_date={">=$(=date(today() - 7))"} >} distinct element))

Hope this helps you.

Regards,

Jagan.

Re: Problem with "Show Partial Sums"

Thu, 19 Dec 2013 00:47:55 GMT

Thank you. It confirmed what I thought.

At the end we decided not to change the chart type nor making any modifications.

I also tried your expression but for some reason did not work.

Re: Problem with "Show Partial Sums"

Thu, 19 Dec 2013 03:49:48 GMT

Hi Marco,

You try above(Jagan Saying) formula it's working fine...