Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Two Dimmensions in a Single Graph

Hello all,

I have the following graph:

QlikView Help12 - Pricing Setting.png

Each point represent a business case.

What I need is, in the same graph, show if each case is either Won or Lost while at the same time seeing which Sales Region it is from, is that posible? Would be better disposicion of the points stay the same.

I thought of doing something like triangles are Won and Squares are Lost, something like this (did this image in Paint):

QlikView Help13 - Pricing Setting.png

Do you think it's feasible? Or if there's some other way?

I'm attaching some mock info to mirror this in order to see how my data loos like.

Thanks!

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Two Dimmensions in a Single Graph

One "hacky" way to solve for the square vs triangle is to use ASCII replacements for Won and Lost as seen below (and also in the QVW attached to original reply.).

If he changes the symbol for Region to a dot and changes Won to a triangle and Lost to a Square, you get the below.  I also applied red/green color logic as an additional visualization call out and added a Text in Chart key for the additional symbols... but who knows how that will react on an access point deployment.

Solution-B.PNG

View solution in original post

18 Replies
Highlighted
Champion
Champion

Re: Two Dimmensions in a Single Graph

Hi,

take a look at this.

Highlighted

Re: Two Dimmensions in a Single Graph

What I need is, in the same graph, show if each case is either Won or Lost while at the same time seeing which Sales Region it is from, is that posible?

Does question is finished?

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
Contributor III
Contributor III

Re: Two Dimmensions in a Single Graph

Youssef this way it's only showing if it's won or lost, but not in which region was it.

Highlighted
Contributor III
Contributor III

Re: Two Dimmensions in a Single Graph

Sorry Anil, I didn't understand your question

Highlighted

Re: Two Dimmensions in a Single Graph

Still question is pending or that's it??

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
Contributor III
Contributor III

Re: Two Dimmensions in a Single Graph

It's still pending!

The second image I added is not from QlikView, I took a screenshot and pasted on Paint Brush to change it

Highlighted
Master II
Master II

Re: Two Dimmensions in a Single Graph

Hi,

like this? how u wanted to show that legent ? (mean u need to show sales region instead of status?)

Dimension:

Case#

[Sales Region]


Measure:

Won

sum({$<[Case Status]={"Won"}>} [Final Price])

Lost

sum({$<[Case Status]={"Lost"}>} [Final Price])

Capture.JPG

Highlighted

Re: Two Dimmensions in a Single Graph

I believe the Line chart is not the feasible for this requirement. Can you change from Line to Grid Chart and check.

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
Contributor III
Contributor III

Re: Two Dimmensions in a Single Graph

The issue with the grid chart is that it doesn't order them from highest to lowest while mixing the two different status. Its spheres are also not the best approach in order to see the values.

Not sure if this helps, but the case number is not that important.