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

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

abg_emea — Wed, 25 Nov 2020 16:16:04 GMT

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.

=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

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

satishkurra — Wed, 11 Jul 2018 16:05:51 GMT

Can you try unchecking the null value option in dimension.

Refer attached screenshot

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

ramasaisaksoft — Wed, 11 Jul 2018 17:00:26 GMT

Hi Dude,

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

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

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

Pragya — Mon, 02 Mar 2020 19:24:14 GMT

Hi,

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

thanks