Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Partial Sum issue in pivot table

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?

2 Replies
Highlighted
Luminary
Luminary

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

can you attach your app?

Highlighted
Specialist
Specialist

Hi Christopher,

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