Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
uacg0009
Partner - Specialist
Partner - Specialist

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
Kushal_Chawda

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
awhitfield
Partner - Champion
Partner - Champion

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

uacg0009
Partner - Specialist
Partner - Specialist
Author

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?

Anil_Babu_Samineni

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)
uacg0009
Partner - Specialist
Partner - Specialist
Author

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.

Anil_Babu_Samineni

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)
uacg0009
Partner - Specialist
Partner - Specialist
Author

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

Kushal_Chawda

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

awhitfield
Partner - Champion
Partner - Champion

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

uacg0009
Partner - Specialist
Partner - Specialist
Author

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