Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Strange Barchart layout when limit the second dimension

Hi all,

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

Strange Barchart layout when limit the second dimension.PNG

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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.

Capture.JPG

View solution in original post

15 Replies
Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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?

Highlighted

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.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

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.

Highlighted

Data Visualization.

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

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Partner
Partner

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...

Highlighted
MVP
MVP

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

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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