Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abg_emea
Contributor II
Contributor II

How can I edit and remove the unknown bar in the Bar Graph

Hi There,

I'm pretty much new to qlik. I'm bit struggling with frequency of age group bar chart. I find bit strange in the chart with grey bar which there no data allocated. And I can't even click on it see who are they. The script below is what I have used for the Graph.

Please if any could help me out. Would be really help.

Age group.png

=if (DRIVERAGE<21, '<21',

if (DRIVERAGE>=21 and DRIVERAGE<24, '21-24',

if (DRIVERAGE>=25 and DRIVERAGE<29, '25-29',

if (DRIVERAGE>=30 and DRIVERAGE<34, '30-34',

if (DRIVERAGE>=35 and DRIVERAGE<39, '35-39',

if (DRIVERAGE>=40 and DRIVERAGE<44, '40-44',

if (DRIVERAGE>=45 and DRIVERAGE<45, '45-49',

if (DRIVERAGE>=50 and DRIVERAGE<54, '50-54',

if (DRIVERAGE>=55 and DRIVERAGE<59, '55-59',

if (DRIVERAGE>=60 and DRIVERAGE<64, '60-64',

if (DRIVERAGE>=65 and DRIVERAGE<69, '65-69',

if (DRIVERAGE>=70, '70+'))))))))))))

Regards

NR

3 Replies
satishkurra
Specialist II
Specialist II

Hi

Can you try unchecking the null value option in dimension.

Refer attached screenshot

ramasaisaksoft

Hi Dude,

you need to Un-check the Null Values Option available in the Dimension Field.

1.png

Let us know if you face any issue .Else close the thread.

Pragya
Creator
Creator

Hi,

saw your solution today. I was facing the same problem and my problem is solved.

thanks