Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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,

Labels (1)
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