Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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)