topic Re: Two Dimmensions in a Single Graph in QlikView

Two Dimmensions in a Single Graph

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

I have the following graph:

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):

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!

Re: Two Dimmensions in a Single Graph

YoussefBelloum — Tue, 12 Dec 2017 17:22:47 GMT

Hi,

take a look at this.

Re: Two Dimmensions in a Single Graph

Anil_Babu_Samineni — Tue, 12 Dec 2017 17:23:02 GMT

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?

Re: Two Dimmensions in a Single Graph

Anonymous — Tue, 12 Dec 2017 17:25:31 GMT

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

Re: Two Dimmensions in a Single Graph

Anonymous — Tue, 12 Dec 2017 17:27:02 GMT

Sorry Anil, I didn't understand your question

Re: Two Dimmensions in a Single Graph

Anil_Babu_Samineni — Tue, 12 Dec 2017 17:29:04 GMT

Still question is pending or that's it??

Re: Two Dimmensions in a Single Graph

Anonymous — Tue, 12 Dec 2017 17:31:21 GMT

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

Re: Two Dimmensions in a Single Graph

devarasu07 — Tue, 12 Dec 2017 17:44:34 GMT

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])

Re: Two Dimmensions in a Single Graph

Anil_Babu_Samineni — Tue, 12 Dec 2017 17:50:16 GMT

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

Re: Two Dimmensions in a Single Graph

Anonymous — Tue, 12 Dec 2017 18:00:47 GMT

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.

Re: Two Dimmensions in a Single Graph

Anonymous — Tue, 12 Dec 2017 18:01:16 GMT

Something like this, the issue is how I add the 2nd dimmension and how do I display its legend.

With only one dimmension I already managed to do.

Re: Two Dimmensions in a Single Graph

johnca — Tue, 12 Dec 2017 19:05:50 GMT

This will probably not work since your data is probably just a subset of a larger set, but it might give you some ideas. I started by creating a new dimension with the Case # with value of the Final Price using Dual. Please see attached.

Re: Two Dimmensions in a Single Graph

justinvchiang — Tue, 12 Dec 2017 22:08:33 GMT

Marcelo,

How about something like this?

This solution is using Case # and Sales Region as the dimension and sum(Final Price]) as the expression. Then to get the Status in as well, I added an additional expression as only([Case Status]) with Display Option as Value on Data Points.

Re: Two Dimmensions in a Single Graph

Anil_Babu_Samineni — Wed, 13 Dec 2017 05:12:49 GMT

This one makes nice !!! But, His intend to show "Square Diagrams" for Lost. If you are the one who did that please share final Version of QVW. He may easy tackle the same

Re: Two Dimmensions in a Single Graph

justinvchiang — Wed, 13 Dec 2017 16:50:15 GMT

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.

Re: Two Dimmensions in a Single Graph

Anonymous — Thu, 14 Dec 2017 11:23:47 GMT

Hello Justin,

How do I do that with ASCII? I'm not very familiar with it.

Re: Two Dimmensions in a Single Graph

justinvchiang — Thu, 14 Dec 2017 16:08:42 GMT

Hey Marcelo,

In Qlik you can use chr() codes that correspond to specific ASCII characters that aren't on your typical keyboard.

In this case the Triangle is chr(9650) & the Square is chr(9632)

So that expression could be

if(only([Case Status]) = 'Won', chr(9650),
if(only([Case Status]) = 'Lost', chr(9632)
, null()))

Re: Two Dimmensions in a Single Graph

Anonymous — Thu, 14 Dec 2017 18:34:24 GMT

What about the colors (red for lost and green for won)?

Could you give me their codes too so I can add to the script?

Thanks!

Re: Two Dimmensions in a Single Graph

justinvchiang — Thu, 14 Dec 2017 19:03:09 GMT

Sure, for the colors just click the + expansion icon on your primary measure expression and add this as the text color expression:

if(only([Case Status]) = 'Won', green(), red())