How to see Null lines in chart

[Anonymous]

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

[YoussefBelloum]

Hi,

maybe stalwar1‌ can take a look here ?

[qlikviewwizard]

hI darrihilmarsson

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

How you got?

Company Name               Amount

Walmart                             100

-                                          540

[ogautier62 · Accepted solution]

Hi

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