Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mikelees80
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
Chanty4u
MVP
MVP

Hi

do this

hand.PNG

Chanty4u
MVP
MVP

or try thisfull.PNG

mikelees80
Contributor
Contributor
Author

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

try this =Alt(yourexpression, 0)

Chanty4u
MVP
MVP

or try

lF(IsNull(UrExp),0,UrExp)

or


NumSum(urExp)

hope this helps

mikelees80
Contributor
Contributor
Author

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

mikelees80
Contributor
Contributor
Author

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

can you share sample app?

pradosh_thakur
Master II
Master II

what about

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

Learning never stops.