left join and right join on graphics

[warrentk80]

Goodmorning everyone

I am creating a dashboard for tracking sales.

I need to have two graphs, one of the products not sold, one of the products sold out of print.

I can not identify cases of null, but always all values.

attached sample of the dashboard that I have to carry

someone would know me out?

Thank you

Andrew

[sunny_talwar]

Are you trying to replicate your excel result in your QlikView document?

[t_chetirbok · Accepted solution]

Hi!

Please find the attachment !

Is it that you want?

[warrentk80]

Please find enclosed the two tables that I would get

thank you

[warrentk80]

Please find enclosed the two tables that I would get

thank you

[sunny_talwar]

Check out the attached

[t_chetirbok]

in second table use expression if(isnull(Prodotto), Quantita,0)