topic Partial Sum issue in pivot table in QlikView

Partial Sum issue in pivot table

udaya_kumar — Fri, 06 Mar 2015 09:41:23 GMT

Hi,

I have data with country, branches and total working days data for 2013 and 2014 year.

Data is available for all the branches in 2014, but not all branches has data in 2013 year.

I have created a pivot table with country, branches as dimension and

one expression for 2014 and another expression for 2013.

The "Show Partial Sum" functionality is working properly for 2014 year expression, but 2013 expression

the total value is showing null.

Expression used for 2014 is

num(only({<Year={$(=max({1}Year))},Type={'Current'}>}Total_workdays),'#,###.##')

for 2013

num(only({<Year={$(=max({1}Year)-1)},Type={'Current'}>}Total_workdays),'#,###.##')

How to solve this issue?

chrislofthouse — Fri, 06 Mar 2015 10:16:09 GMT

Is there data for Total-workdays where Year = 2013 and Type = Current?

can you attach your app?

udaya_kumar — Fri, 06 Mar 2015 10:26:45 GMT

Hi Christopher,

Data is available for year = 2013 and Type = Current, but data is not available for all the branches.