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

[#1]

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

[#2]

Hi

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

[#3]

Hi Jochen,

here you have a working example.

Good luck!

Rainer

[#4]

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 !!!!

[#5]

Hi Jochen,

here are a modified example.

Hope you get it now.

Rainer

[#6]

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

It seems my mind isn't awake today

[#7 · Accepted solution]

Hi Jochen,

here are the third shot.

It´s O.K now?

Rainer

[#8]

It works !!!