topic See dimensions with nullvalue measure in table in App Development

See dimensions with nullvalue measure in table

stha142020 — Fri, 20 Aug 2021 08:02:06 GMT

Hi,

Qlik tables hides dimension rows with nullvalue measures by default:

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

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

Thanks!

Vegar — Fri, 20 Aug 2021 08:26:45 GMT

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 — Fri, 20 Aug 2021 08:36:21 GMT

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 — Fri, 20 Aug 2021 08:40:28 GMT

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.