Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvvvvv
Creator
Creator

Show dimension with without record

Is it possible to show the bar without measure in bar chart?
Like the following
ColA, ColB

1,B

1,V

2,V

4,G

Is is possible to show the dimension from 1-4 in bar chart while ColA = 3 with zero record?

Labels (3)
1 Solution

Accepted Solutions
Saravanan_Desingh

3 Replies
lironbaram
Partner
Partner

hi 

short answer is no, only available dimension values are presented in the chart

but you can use a calculated dimension like this 

=ValueLoop(vMin,vMax,1) where vMin in the minimum value of ColA and vMax is the maximum value 

and expression like this 

sum(if(ValueLoop(vMin,vMax,1)=ColA,ColC))

be aware that using this method might cause some performance issues in large data sets 

 

Saravanan_Desingh

One solution is.

tab1:
LOAD * INLINE [
    ColA, ColB
    1,B
    1,V
    2,V
    4,G
];

AsOfTab:
LOAD MinC+IterNo()-1 As ColA
While MinC+IterNo()-1 <= MaxC; 
LOAD Min(ColA) As MinC, Max(ColA) As MaxC
Resident tab1;
Saravanan_Desingh