Replace '-' or null value with 0 in Pivot table Qlik sense

[Neha121]

Hi All,

   I have a pivot table in Qliksense which has data like below: 

Now the user doesn't want to see - for null he wants to see 0 in column F and G and 'Yes' in Column H like below

How can we do it in formula? or do I have to do some coding at the backend?

[MatheusC · Accepted solution]

@Neha121 
These nulls occur due to the of missing data in the join. That said, the solution is the new pivot table released by Qlik in custom objects, which provides this treatment in the chart properties.

Check if it is available in your version of Qlik. Alternatively, the Vizlib extension might also be able to handle it.


- Matheus

[Neha121]

Thanks @MatheusC , I was able to achieve it thanks a lot.. However for my "meets hurdle" I want to add 'Yes' if the count is 0..I have tried with isnull() doesnt work..  formula for meets hurdle is : 

if (Count({<[Threshold Flag]={'1'}>} [Claim Number])/aggr(Count([Claim Number]),PhysicalorNonPhysical,Policy) > 75 ,'Yes','No')

like 

[MatheusC · Accepted solution]

The new pivot table, although it can modify the missing null field, only has fixed values, so it does not support expressions, currently not.

- Matheus