Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
or try this
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
try this =Alt(yourexpression, 0)
hope this helps
i'm afraid Alt doesn't work either, i'm guessing because the value is missing for that Item Date combination
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!!
can you share sample app?