topic Re: Set Analysis - not show zero in QlikView

Set Analysis - not show zero

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

in the image below you see that the sales at 20-02-2016 of articlenumber 284188. The expression Sales ( sum(salesprice*transactionquantity) showed as €0,0.

But this must be €235,0 (i contacted with my sales colleague). how can i set my expression to turn the €0,0 into the value of expression Sales sum(salesprice*transactionquantity) ?

Thanks all!

Re: Set Analysis - not show zero

luciancotea — Wed, 20 Apr 2016 10:37:01 GMT

Add the price as dimension, after the date and post the result back.

Re: Set Analysis - not show zero

avinashelite — Wed, 20 Apr 2016 10:37:38 GMT

is it the complete expression your using ?? or a part of the expression

Re: Set Analysis - not show zero

sunny_talwar — Wed, 20 Apr 2016 10:37:57 GMT

We can't be sure of why it shows as 0. Can you may be share a sample?

Re: Set Analysis - not show zero

alexandros17 — Wed, 20 Apr 2016 10:38:57 GMT

You could try with

sum(salesprice)*Sum(transactionquantity)

but I think that for the day 20/02/2016 there is a combination of data that exclude salesprice or transactionquantity so it's better to check data.

Let me now

Re: Set Analysis - not show zero

Wed, 20 Apr 2016 10:47:28 GMT

Hello Allesandro,

if i use sum(salesprice)*Sum(transactionquantity)

the expression show a €0,0.

Re: Set Analysis - not show zero

Wed, 20 Apr 2016 10:50:32 GMT

Hey Lucian,

se the screenshot below. Still the sales price is €0,0.

Re: Set Analysis - not show zero

Wed, 20 Apr 2016 10:53:23 GMT

Hello Sunny,

Here you are. please check at the sheet NOS Articles.

thanks !

Re: Set Analysis - not show zero

luciancotea — Wed, 20 Apr 2016 10:58:14 GMT

So, the sales price is 0. Fix that.