Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ahmadov_10
Contributor
Contributor

Available solutions to replace " - " to 0 in pivot table

Hi Experts, any solutions to replace - by 0 in my pivot table (it's shown - because we didn't have result for the specific month)

PS :

rows : Category

columns : month-Year like : sept.2017

value : salesAmount

Qlik17.PNG

Labels (2)
1 Reply
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

In the script, I will try something like this

LOAD 

fld1,fld2......,

IF(ISNULL(salesAmount),0,salesAmount)    AS [salesAmount]

FROM [lib://QVD/DATA.qvd](qvd);

 

OR 

In the Chart try

ALT(SUM([salesAmount]),0)