Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Working with two dims in a graph

I usually find confusing the representation of tow dimension in a graph.

I have only a expression, but two dims.

Is there any best practices in Qlickview to deal with 2 dims in a graph?

Thanks in advance,

1 Solution

Accepted Solutions
maleksafa
Specialist
Specialist

can you give more example on the type of chart you are dealing with, if it is a straight or pivot chart then there are no problem, now sometimes with bar/line charts you face some issues, and what you can do is to create one dimension which is a concatenation of the 2 dimensions that you want to show.

View solution in original post

11 Replies
beck_bakytbek
Master
Master

Hi Juan

What do you mean exactly. you can use in such cases the cyclic-group.

Beck

maleksafa
Specialist
Specialist

can you give more example on the type of chart you are dealing with, if it is a straight or pivot chart then there are no problem, now sometimes with bar/line charts you face some issues, and what you can do is to create one dimension which is a concatenation of the 2 dimensions that you want to show.

Anonymous
Not applicable
Author

I am working with a bar graph, I think is the best graph to show the values with 2 dims, isn't it?

To make a cyclic-gruop is useful too.

If you have any other advice to visualize the data, tell me please...

Thanks in advance

awhitfield
Partner - Champion
Partner - Champion

Hi Juan,

can you post a example qvw? Do you want to display both of the two dimensions at the same time?

Andy

Anonymous
Not applicable
Author

I want to display both at the same time.

I would like to know the best practices in thsi cases

Thanks!!

a_two_dims.png

Anonymous
Not applicable
Author

Can't you use 2 expressions and even colour them? It could be a solution.

Anonymous
Not applicable
Author

My expresion is very simple: sum(venta)

over ciudad and producto

but I don't know what do yoy mean by using two expression

can you give an example?

Thanks

Anonymous
Not applicable
Author

Also you can try using treilis : https://www.youtube.com/watch?v=y5-xEQKklMw

Or try using cyclic group: https://www.youtube.com/watch?v=TEQy8JuMpp0

Or Animate 2nd dimension

Or select option in listbox (City or 2nd dim): Always one selected value 

Anonymous
Not applicable
Author

HI Juan,

Did you tried "STACKED" option in bar chart? (under STYLE tab) .It may give you more ideas

-Jay