topic Re: missing bars from the bar chart in QlikView

missing bars from the bar chart

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need help...

I tried to create a bar chart with 7 age groups, but the bar chart only show 3 age groups, what went wrong?

Users:
LOAD UserID,
Gender,
Age,
if(Age>0 and Age<=18,'Under 18',
if(Age>18 and Age<=24,'18-24',
if(Age>24 and Age<=34,'25-34',
if(Age>35 and Age<=44,'35-44',
if(Age>45 and Age<=49,'45-49',
if(Age>50 and Age<=55,'50-55','56+')))))) as [Age Group],
Occupation,
ZipCode
FROM
[$(vFilePath)\users.xlsx]
(ooxml, embedded labels, table is users);

Re: missing bars from the bar chart

vishsaggi — Sun, 02 Jul 2017 19:28:18 GMT

Does your bar garph has age groups 35 to 55? Can you share this sample to look into?

Re: missing bars from the bar chart

antoniotiman — Sun, 02 Jul 2017 22:12:11 GMT

Hi Wee,

may be

if(Age>0 and Age<=18,'Under 18',
if(Age>18 and Age<=24,'18-24',
if(Age>24 and Age<=34,'25-34',
if(Age>34 and Age<=44,'35-44',
if(Age>44 and Age<=49,'45-49',
if(Age>49 and Age<=55,'50-55','56+')))))) as [Age Group],
Regards,

Antonio

Re: missing bars from the bar chart

prma7799 — Mon, 03 Jul 2017 02:42:27 GMT

Please share some sample app with data

Re: missing bars from the bar chart

Mon, 03 Jul 2017 12:19:05 GMT

Hello everyone,

Thanks for your replies.

My freind has resolved the problem. Many thanks and appreciate all your valueable inputs.

Regards,

Wee

Re: missing bars from the bar chart

jmvilaplanap — Mon, 03 Jul 2017 13:38:03 GMT

To recode like this, I think is easy to don't have gaps in between years:

LOAD

UserID,

Gender,

Age,

if(Age<=18,'Under 18',

if(Age<=24,'18-24',

if(Age<=34,'25-34',

if(Age<=44,'35-44',

if(Age<=49,'45-49',

if(Age<=55,'50-55','56+')))))) as [Age Group],

Occupation,

ZipCode

FROM

[$(vFilePath)\users.xlsx]

(ooxml, embedded labels, table is users);

And if you have gaps, maybe you don't have data for those intervals.

Regards