Show all rows in dimension

[D19PAL]

Hi,

I've got a dimension and a measure.  The table is only showing the rows where I have numbers.  I want to show where I got nulls too.

Table

Dim,measure

A, 10

C, 5

How I want it

Dim,Measure 

A,10

B,

C,5

THANKS

[vchuprina]

Hi,

In Qlikview on presentation tab deselect 'Supress Zero-values' check box.

Result:

In Qliksense select "Include zero values" checkbox in Add-ons tab

Regards,

Vitalii

[D19PAL]

But first I'll need to convert nulls to 0?

[vinieme12 · Accepted solution]

The problem is where you are sourcing the dimension from

In such scenario  you should be sourcing dimensions from a separate dimension table which has all possible dimension values, like below.

facttable:
Load * Inline [
dimkey,dim2,measure
A,A,10
C,C,5
];

dimensiontable:
Load * Inline [
dimkey,dim
A,A
B,B
C,C
];
exit Script;

Now create a chart with dim from dimensiontable; sum(measure) and check Include Zero Values

Do not use key fields used to associate tables as dimensions in your chart

both tables have Include zero values checked, but as you can see dim sourced from a separate dimensiontable will show 0 when there is no associated data 

Output

[vinieme12]

@D19PAL kindly close the thread by accepting a response as solution