topic Re: Suppress when value is null chart issue in QlikView

Suppress when value is null chart issue

Tue, 29 Nov 2016 21:24:34 GMT

Is it possible to suppress a dimension when the value is null and have an expression that calulates a percentage and the total of that percentage adds up to 100.

See the example below.

Person	Sales	% of Total Sales
Sam	10	10%
John	25	25%
Mark	50	50%
TOTAL	85	85% instead of 100%

--in this example, there are 15 sales that are 'null' and I don't want to include. However, I still want the % to add up to 100 when I suppress null values

Re: Suppress when value is null chart issue

swuehl — Tue, 29 Nov 2016 21:39:16 GMT

It seems I don't understand how you calculate your % from the sales values (not even the detail lines).

Could you explain how your calculation works?

Or post a small sample QVW?

Re: Suppress when value is null chart issue

swuehl — Tue, 29 Nov 2016 21:40:37 GMT

Or maybe your sales are not NULL, but the dimension Person these sales are linked to?

Re: Suppress when value is null chart issue

swuehl — Tue, 29 Nov 2016 21:41:41 GMT

What about

=Sum(Sales) / $(=Sum(Sales))

Re: Suppress when value is null chart issue

vishsaggi — Tue, 29 Nov 2016 21:41:43 GMT

Check the box Supress when value is Null in the Dimensions tab! Try like this as attached.

Updated!

Re: Suppress when value is null chart issue

lironbaram — Tue, 29 Nov 2016 21:44:44 GMT

use this expression to calculate the share

sum(Sales)/sum({<Person=p(Person)>}Total Sales)

Re: Suppress when value is null chart issue

Tue, 29 Nov 2016 21:58:21 GMT

Thanks everyone, I was able to figure it out with all of your help!! Sum(Sales)/$(=Sum(Sales) worked!!!!