Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_2583
Creator
Creator

Blank Values to 0 in a Pivot

Hi, 

I have created a table and pivot and both use the same measure. Why in my table do I get '0' values, yet in my pivot, I get '-' values? 

Is there anyway to change the pivot from '-' to '0' please? 

I have tried various things on the forum, but nothing works and wondered if there are other idea floating around to help.

My calculation is a simple: sum(sale)

3 Replies
Fernando_Fabregas

Hi Thomas!

The only way I did found to show zeros in Pivot tables was to add rows with zeros (ie: sale=0) for each combination of dimensions (ie: customer, region, etc.) that not exists in data model.

Regards, Fernando

micheledenardi
Specialist II
Specialist II

Try this expression: sum(alt(sale,0))

PradeepK
Creator II
Creator II

Might as well move alt(sale,0) to load script.. to keep it consistent.