topic Re: QlikSense Missing Symbols vs QlikView in App Development

QlikSense Missing Symbols vs QlikView

mikelees80 — Tue, 12 Dec 2017 10:54:41 GMT

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

Re: QlikSense Missing Symbols vs QlikView

Chanty4u — Tue, 12 Dec 2017 10:57:05 GMT

do this

Re: QlikSense Missing Symbols vs QlikView

Chanty4u — Tue, 12 Dec 2017 10:58:03 GMT

or try this

Re: QlikSense Missing Symbols vs QlikView

mikelees80 — Tue, 12 Dec 2017 11:03:26 GMT

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

Re: QlikSense Missing Symbols vs QlikView

Chanty4u — Tue, 12 Dec 2017 11:08:25 GMT

try this =Alt(yourexpression, 0)

Re: QlikSense Missing Symbols vs QlikView

Chanty4u — Tue, 12 Dec 2017 11:09:50 GMT

or try

lF(IsNull(UrExp),0,UrExp)

NumSum(urExp)

hope this helps

Re: QlikSense Missing Symbols vs QlikView

mikelees80 — Tue, 12 Dec 2017 11:10:59 GMT

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

Re: QlikSense Missing Symbols vs QlikView

mikelees80 — Tue, 12 Dec 2017 11:25:42 GMT

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

Re: QlikSense Missing Symbols vs QlikView

Chanty4u — Tue, 12 Dec 2017 11:26:28 GMT

can you share sample app?

Re: QlikSense Missing Symbols vs QlikView

pradosh_thakur — Tue, 12 Dec 2017 13:52:38 GMT

what about

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

Re: QlikSense Missing Symbols vs QlikView

simonaubert — Mon, 06 May 2019 11:06:33 GMT

Well, I tried all above solution and not a single one works. 😞

So I created this idea at least https://community.qlik.com/t5/Qlik-Sense-Enterprise-Ideas/Missing-value-and-Measure-Display/idi-p/1576862

If you want to vote 😉