topic Chart - sorting (ZG-G-S-ZS) in QlikView

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 08:33:03 GMT

Hello guys,

I'm back... [:^)]

I have several tables with a field input (field 1A1) : ZG - G - S - ZS

ZG = Zeer Goed (English : very good)
G = Goed (English : good)
S = slecht (English : bad)
ZS = zeer slecht (English : very bad)

I want to create a chart (that's the simpliest chart I ever made) with amount of ZG-G-S-ZS but the first bar should be ZG, the second G, 3° S and 4° ZS

Greetings,

Jochen

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 08:42:54 GMT

You could use the dual-function in the loadscript to create a numerical representation of that field.
Then it's no problem to sort the way you want.

/Fredrik

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 09:06:43 GMT

Hi Jochen,

here you have a working example.

Good luck!

Rainer

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 09:19:17 GMT

Very simple example, THX !!!!

Let me explain my problem :

I have 1 table with 19 fields which can be ZG - G - S - ZS

Fields : 1A1, 1A2, 1A3, 1A4,... 1B1, 1B2,...

1A1 1A2 1A3 1A4 1A5 1A6 1A7 1A8 1B1 1B2 1B3 ...

ZG ZG G G G ZG S G ZG G G

G G S ZG ZG G S ZG G G G

and so on...

After all this time, I'm still full of wonder about the support !!!!

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 10:02:51 GMT

Hi Jochen,

here are a modified example.

Hope you get it now.

Rainer

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 10:25:34 GMT

I attached the simple version of the QV-file...

It seems my mind isn't awake today

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 13:34:34 GMT

Hi Jochen,

here are the third shot.

It´s O.K now?

Rainer

Chart - sorting (ZG-G-S-ZS)

Fri, 08 Jan 2010 13:56:16 GMT

It works !!!