topic Strange Barchart layout when limit the second dimension in QlikView

Strange Barchart layout when limit the second dimension

uacg0009 — Mon, 24 Jul 2017 09:02:19 GMT

Hi all,

I found that when my barchart has 2 dimensions, the layout shows wrong and I don't know why.

You can see my example data and the barchart, there are some strange space in the barchart.

And I want to get the top 3 per month, I can done the function, but the layout is strange.

Do you know why and any method to solve that?

Thanks.

Aiolos Zhao

Re: Strange Barchart layout when limit the second dimension

awhitfield — Mon, 24 Jul 2017 09:32:24 GMT

Are the gaps not just where you don't have any values for your dimensions? e.g. you have no values for month 5 for Companies SSS, FFF and WWW.

Andy

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Mon, 24 Jul 2017 09:38:03 GMT

thanks for reply, and are you sure with that? it looks like a bug in qlikview I think, or do you have any method to solve that?

Re: Strange Barchart layout when limit the second dimension

Anil_Babu_Samineni — Mon, 24 Jul 2017 10:07:39 GMT

I don't think so whether we can suspect those null value when we have 2 dimensions? the moment you are talking is and DV is good. But, one free idea - How about Subtype (Stacked) rather Grouped.

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Mon, 24 Jul 2017 10:19:00 GMT

what's DV?

Actually I tried the Stacked, it's fine. but I want grouped...because I want to show the comparison among these values.

so...any ideas? I have suppress the null value in dimension, but it's useless.

Re: Strange Barchart layout when limit the second dimension

Anil_Babu_Samineni — Mon, 24 Jul 2017 10:30:27 GMT

Data Visualization.

And i refer this !!! If comparison then Grouped may good rather Stacked

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Mon, 24 Jul 2017 10:33:18 GMT

Yes, I have tried this, but grouped has problem like I said... so I don't know what to do now...

I want to use grouped but...

Re: Strange Barchart layout when limit the second dimension

Kushal_Chawda — Mon, 24 Jul 2017 10:49:18 GMT

These gaps are due to Company vales are missing from some of the months, for eg. In month 5 you have 5 Company while in month 6 You have just 2. So that Space is there due to missing Company value

Re: Strange Barchart layout when limit the second dimension

awhitfield — Mon, 24 Jul 2017 11:42:37 GMT

Hi again,

would you really have months were companies have 'null' sales if you were using 'real' data? If not, then you wouldn't have the issue..

Andy

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Tue, 25 Jul 2017 01:58:32 GMT

thanks for reply, but even I tried the check the suppress missing in presentation tab, it doesn't work, I think it's like a bug, because it's really stupid if the chart keep the space even I don't have the value.

So do you have any ideas to solve or replace that?

Thanks

Aiolos

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Tue, 25 Jul 2017 02:00:29 GMT

Hi Andrew,

Yes, for real data, because company join to us one by one,and I can't make every company has data in every month...

So i met this problem..

do you think it's no way to solve that? because I'm going to give up...it takes me too much time.

Aiolos

Re: Strange Barchart layout when limit the second dimension

Kushal_Chawda — Tue, 25 Jul 2017 07:15:42 GMT

Suppress values will not work, because month is your primary dimension and categories are associated with each month which is secondary dimension. So for example if for particular month if you have values for 5 Companies and for another month only two Companies, so missing company cannot be suppressed because it's there for first month.

To your problem I think you need to create a separate transformed table

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Tue, 25 Jul 2017 07:35:21 GMT

so do you mean i need to do 3 tables to show different month data?

but the problem is that for real data I don't know how many month we have or customer choose...

Re: Strange Barchart layout when limit the second dimension

Kushal_Chawda — Tue, 25 Jul 2017 08:47:14 GMT

Another solution could be like, create composite dimension of Month & Company. Use color with Fieldindex function to give color to each company. And use straight table as customized legend.

Re: Strange Barchart layout when limit the second dimension

uacg0009 — Tue, 25 Jul 2017 09:07:21 GMT

Hi kushal,

thanks for reply, actually I considered this method before, but you can see my question :

I want to get the top 3 per month, then I didn't try to use this method.

But just now I did a aggr in dimension...and I made it..

well, thank you so much to remind me this method.

Aiolos Zhao

Re: Strange Barchart layout when limit the second dimension

Kushal_Chawda — Tue, 25 Jul 2017 09:10:51 GMT

No problem