Qlik Community

Qlik Sense App Development

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

mikelees80
New 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

9 Replies
Chanty4u
Esteemed Contributor III

Re: QlikSense Missing Symbols vs QlikView

Hi

do this

hand.PNG

Chanty4u
Esteemed Contributor III

Re: QlikSense Missing Symbols vs QlikView

or try thisfull.PNG

mikelees80
New Contributor

Re: QlikSense Missing Symbols vs QlikView

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
Esteemed Contributor III

Re: QlikSense Missing Symbols vs QlikView

try this =Alt(yourexpression, 0)

Chanty4u
Esteemed Contributor III

Re: QlikSense Missing Symbols vs QlikView

or try

lF(IsNull(UrExp),0,UrExp)

or


NumSum(urExp)

hope this helps

mikelees80
New Contributor

Re: QlikSense Missing Symbols vs QlikView

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

mikelees80
New Contributor

Re: QlikSense Missing Symbols vs QlikView

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
Esteemed Contributor III

Re: QlikSense Missing Symbols vs QlikView

can you share sample app?

pradosh_thakur
Honored Contributor II

Re: QlikSense Missing Symbols vs QlikView

what about

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

Learning never stops.
Community Browser