See dimensions with nullvalue measure in table

[stha142020]

Hi,

Qlik tables hides dimension rows with nullvalue measures by default:

ID	Sum(Sales)
1	100
2	50
5	10
6	50

Is there a way to display all dimensions regardless of measures?

ID	Sum(Sales)
1	100
2	50
3	-
4	-
5	10
6	50

And I want to be able to select ID's:

ID	Sum(Sales)
1	100
3	-

Thanks!

[Vegar]

You need to get all desired IDs into your datamodel somehow. Consider this script.

Data:
LOAD *
inline [
  ID, Sales
  1, 100
  2, 50
  3
  4
  5,10
  6, 50
];

You will be able to select any ID and it will give you this output using ID and Sum(Sales)

[stha142020]

Hi,

Thanks for the reply!

The ID's and Sales are in two different tables in my datamodel.
They are to big to be merged.

[Vegar]

Thats ok, it should work as well. 

SalesData:
LOAD *
inline [
ID
1
2
3
4
5
6];

SalesData:
LOAD *
inline [
  ID, Sales
  1, 100
  2, 50
  5,10
  6, 50
];

Make sure you got the i "Include zero values" checked in the property pane.