Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
But first I'll need to convert nulls to 0?
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
@D19PAL kindly close the thread by accepting a response as solution