topic Working with two dims in a graph in QlikView

Working with two dims in a graph

Anonymous — Thu, 07 May 2015 10:57:50 GMT

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,

Re: Working with two dims in a graph

beck_bakytbek — Thu, 07 May 2015 11:00:43 GMT

Hi Juan

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

Beck

Re: Working with two dims in a graph

maleksafa — Thu, 07 May 2015 11:02:48 GMT

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.

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 11:27:42 GMT

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

Re: Working with two dims in a graph

awhitfield — Thu, 07 May 2015 11:40:49 GMT

Hi Juan,

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

Andy

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 11:49:16 GMT

I want to display both at the same time.

I would like to know the best practices in thsi cases

Thanks!!

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 11:59:06 GMT

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

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 12:11:44 GMT

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

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 12:31:07 GMT

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

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 12:35:47 GMT

HI Juan,

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

-Jay

Re: Working with two dims in a graph

Anonymous — Thu, 07 May 2015 20:16:41 GMT

Thanks Thomas,

It's reaaly heplful. I didn't know this options...

Re: Working with two dims in a graph

Anonymous — Fri, 08 May 2015 06:21:45 GMT

I'm glad I could help