topic Re: Two dimension Chart visualization in QlikView

Two dimension Chart visualization

chadwatson — Wed, 10 Jun 2015 16:45:19 GMT

I am trying to create a bar chart with two dimensions and one measure. I would like both dimensions to show on my chart. I found in another discussion that to do this I needed to create a second measure and give it a value of 0. That worked, however every single value from the second dimension is being duplicated for every value in the first dimension:

The ones I've circled in red do not belong in those campuses. Here is the source data:

The measure is a calculation of how many weekdays there are between the effective date and end date:

=sum(NetWorkDays(iun_effective_date,iun_ending_date))

What I want to do is to get rid of those names that don't belong with the first level dimension. I've tried everything I can think of from checking "Suppress when Value Is Null" in the dimensions to "Supressing Zero-Values" in the Presentation. Does anyone have any other ideas? I'm not sure if it has to do with how I'm calculating the measure or something else.

Thanks!!!

Re: Two dimension Chart visualization

caio_caminoski — Wed, 10 Jun 2015 16:58:41 GMT

Hi Chad,

Can you post a sample of your app?

Cheers

Re: Two dimension Chart visualization

chadwatson — Wed, 10 Jun 2015 17:26:05 GMT

It looks like someone just changed some test data I was working with so I'll see if I can recreate it.

Re: Two dimension Chart visualization

chadwatson — Wed, 10 Jun 2015 18:20:48 GMT

Here is the file. Thanks for your help!

My end goal is to sort first by campus numerically, then secondly by ins_full_name desc.

My second chart concats the two together which only shows the records I want, but then I have a hard time figuring out the sort, Plus I don't want to duplicate the campus number on every row; I'd prefer to have it there once.

Re: Two dimension Chart visualization

martynlloyd — Wed, 10 Jun 2015 18:38:40 GMT

You could simplify it and create a concatenated dimension (in script) - then you get rid of the two dimension problem...

Kind regards,

Marty.

Re: Two dimension Chart visualization

chadwatson — Wed, 10 Jun 2015 19:01:17 GMT

Hi Marty,

In my example I attached I did that but then I have duplicated my first dimension for every row and it makes it harder to sort properly.

Re: Two dimension Chart visualization

Digvijay_Singh — Thu, 11 Jun 2015 08:58:15 GMT

Hi,

Please check if this representation helps by writing small script and using dimension accordingly, attaching chart qvw as well.

temp1:
Load *, [IU Campus] & '-' & ins_full_name as [IU_INS]
Resident temp;

Thanks,

Re: Two dimension Chart visualization

martynlloyd — Thu, 11 Jun 2015 11:17:13 GMT

Hi Chad,

Are you hiding null values in your chart - it should only show rows that have a non-null expression result...

Marty.

Re: Two dimension Chart visualization

chadwatson — Thu, 11 Jun 2015 17:03:37 GMT

Hi Marty,

Yes, I have checked those checkboxes but they have no effect.

Thanks,

Chad

Re: Two dimension Chart visualization

chadwatson — Thu, 11 Jun 2015 17:06:08 GMT

Thanks Digvijay,

Almost, I have done that as well but I have a couple problems with that way:

1. I prefer to not have it repeat the campus number for every row

2. more importantly I need to be able to sort it first by campus number, then by name's value decending with the the records with the highest numbers on top by campus number.

Chad