topic Re: Show expression result even if null? in QlikView

Show expression result even if null?

harjedalskok — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i wonder if we can "trick" QV to show a zero value even if the expression doesent return any values for a certain selection.

example, if i would make the selection of Month Selection of Januari:

SalesMan Ludwig Pettersson would Not appear, since he has no sales in Januari.

Säljare	Säljare_Kortnamn	År	Januari	Februari	Mars	April	Maj
		66 431 888kr	10 696 026kr	13 934 628kr	17 190 098kr	17 279 568kr	7 331 568kr
Staffan Lundell	STLU	2 994 070kr	343 648kr	810 576kr	724 049kr	1 007 348kr	108 449kr
Stefan Lehnberg	STLE	2 674 122kr	320 281kr	593 376kr	518 382kr	887 290kr	354 793kr
Andreas Löfkvist	ANLO	2 663 713kr	507 721kr	725 624kr	356 542kr	825 711kr	248 115kr
Peter Carlzon	PECA	3 580 418kr	757 438kr	671 960kr	1 026 490kr	679 310kr	445 220kr
Linus Jonasson	LIJO	3 079 908kr	673 560kr	551 400kr	630 081kr	608 867kr	616 000kr
Ludwig Pettersson	LUPE	1 616 414kr	0kr	0kr	731 166kr	544 124kr	341 124kr
Lena Åhström	LEAH	1 238 070kr	215 615kr	309 135kr	110 440kr	531 510kr	71 370kr

The results after selection of Januari. I would like to see Ludwig here but with a zero value on Januari sales.

Säljare	Säljare_Kortnamn	År	Januari
		2 602 648kr	2 602 648kr
Peter Carlzon	PECA	757 438kr	757 438kr
Linus Jonasson	LIJO	673 560kr	673 560kr
Andreas Löfkvist	ANLO	507 721kr	507 721kr
Staffan Lundell	STLU	343 648kr	343 648kr
Stefan Lehnberg	STLE	320 281kr	320 281kr

Thx in advance for the help.

/André

Re: Show expression result even if null?

sunny_talwar — Mon, 16 May 2016 10:12:54 GMT

Have you tried unchecking 'Suppress Zero-Values' on the presentation tab?

Re: Show expression result even if null?

priyarane — Mon, 16 May 2016 10:15:17 GMT

Uncheck Suppress zero values in Presentation tab

Re: Show expression result even if null?

trdandamudi — Mon, 16 May 2016 10:24:32 GMT

I am hoping that you are using Pivot table... So give a try on the below:

In your chart properties, Go to "Presentation" tab and uncheck "Suppress Zero-Values" and this should give you the results.

I am attaching a sample here and hope this helps...

Re: Show expression result even if null?

ankit777 — Mon, 16 May 2016 10:24:34 GMT

There can be a work around. First you need to create a table with customer name and months. This table should have all possible combinations of months and customer name. Now you can join your sales data. Post this , if any sales man has no sales in a particular month, then you will have a null there and you can show that on chart.

Hope that helps

Re: Show expression result even if null?

harjedalskok — Mon, 16 May 2016 10:53:44 GMT

Hi I attach the document, then you could try, cuz the supress zero values doesent seems to do the trick.

could you have a look?

Thx

Re: Show expression result even if null?

sunny_talwar — Tue, 17 May 2016 00:48:42 GMT

What exactly are we working with??