Discussion board where members can get started with Qlik Sense.
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)
rows : Category
columns : month-Year like : sept.2017
value : salesAmount
In the script, I will try something like this
IF(ISNULL(salesAmount),0,salesAmount) AS [salesAmount]
In the Chart try