topic How to see Null lines in chart in QlikView

How to see Null lines in chart

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

Hi, QlikView community

I have two datasets in my qlikview report.

The table companies shows all the companies in the data.

In the dataset there can no companies and three companies in a %key

%key	Company Name	Company Type
1	Disney	CEE
1	Walmart	SHP
1	Coca Cola	CAR
2	Apple	CEE
2	Maersk	CAR

The table Job Ref shows the name of the job ref and the amount on the job ref.

And the %key connects the data

%key	Job Ref	Amount
1	Florida1	100
2	Florida2	220
3	Kansas1	320

And what I am trying to show in my chart is every Company that is Company Type = 'SHP' and if there is shipper for Job Ref I want the chart to show Null.

I want the chart to show this

Company Name Amount

Walmart 100

- 540

I don't if it is best to have calculated dimension or in the script

Re: How to see Null lines in chart

YoussefBelloum — Thu, 19 Jul 2018 09:38:28 GMT

Hi,

maybe stalwar1‌ can take a look here ?

Re: How to see Null lines in chart

qlikviewwizard — Thu, 19 Jul 2018 10:22:51 GMT

hI darrihilmarsson

Can you explain the logic we need to apply for requirement?

How you got?

Company Name Amount

Walmart 100

- 540

Re: How to see Null lines in chart

ogautier62 — Thu, 19 Jul 2018 10:28:21 GMT

it could be that :

with two dimensions :

dimension :

=if(aggr(count({<[Company Type] = {SHP} >} %key),%key)>0, 'Shipping','no shipping')

= aggr(maxString(if([Company Type]='SHP',[Company Name])),%key)

regards