Using Show all values

[#1]

Hi everybody!

Please help -

I have table

Person;Customer;Ware;Amount;

John;C1;Ware1;100;

John;C2;Ware2;200;

Jack;C3;Ware3;300;

I need to get str table with John's sales of ware1 by all customers -

John;C1;100;

John;C2;-;

Problem that Qlik shows only customers with non-zero sales -

John;C1;100;

And if i mark "Show all values" i get this table -

John;C1;100;

John;C2;0;

John;C3;0;

- qlik adds Jack's customers to John (i don't need it at all)

How can i get this table? -

John;C1;100;

John;C2;-;

Thanx.

[#2]

hi,

probably uncheck suppress zero values in the presentation tab of chart properties dialogue.

thanks

tauqueer

[#3]

It depends on what expressions and dimensions you are using. I've attached an example with one possible solution.

Kind regards
Staffan

Support Technician, QlikTech Support