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

Problem with "Show Partial Sums"

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?

3 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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.

Not applicable
Author

Hi Marco,

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