Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

QlikSense Missing Symbols vs QlikView

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

10 Replies
Highlighted
Champion III
Champion III

Hi

do this

hand.PNG

Highlighted
Champion III
Champion III

or try thisfull.PNG

Highlighted
Contributor
Contributor

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

Highlighted
Champion III
Champion III

try this =Alt(yourexpression, 0)

Highlighted
Champion III
Champion III

or try

lF(IsNull(UrExp),0,UrExp)

or


NumSum(urExp)

hope this helps

Highlighted
Contributor
Contributor

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

Highlighted
Contributor
Contributor

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!!

Highlighted
Champion III
Champion III

can you share sample app?

Highlighted
Master II
Master II

what about

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

Learning never stops.