QlikSense Missing Symbols vs QlikView

[mikelees80]

I am currently migrating a QV dashbaord to QS App and I've hit a bit of an issue with the visualisation

Currently in QV my pivot displays " " for missing values as i change the properites

So thePivot displays like this

In QS my pivot table is displaying "-"

Any ideas on how to change QS and the Users don't like having the Grey "-" in the Pivot Table

[Chanty4u]

Hi

do this

[Chanty4u]

or try this

[mikelees80]

Hi

thanks for the reply, that doesn't work as it still shows the "-" and also i want to display the 0, i'm just looking for a way to change the missing symbol ftom "-" to " " or something similar

[Chanty4u]

try this =Alt(yourexpression, 0)

[Chanty4u]

or try

lF(IsNull(UrExp),0,UrExp)

or

NumSum(urExp)

hope this helps

[mikelees80]

i'm afraid Alt doesn't work either, i'm guessing because the value is missing for that Item Date combination

[mikelees80]

i tried this as well lF(IsNull(UrExp),0,UrExp)

The problem is value isn't Null is missing a combination so this sytax doesn't fit.

All we need is Qlik to add the functionality for Pivot tables from QV into QS and i wouldn't have this issue!!

[Chanty4u]

can you share sample app?

[pradosh_thakur]

what about

if(len(trim(UrExp))>0,UrExp,0)