Straight table group

[#1]

Hello Community,

I have a problem with my straight table, i want to create a fields to group my dimensions as on this following picture :

Thanks for the help

Teneman

[fvelascog72]

Hi,

You can create other dimension that groups this dimension in script or a calculated Dimension.

Something in script like:

left([CI 1],1)          as "Group Dimension"

[stigchel]

Preferable in load script, you can use (if that's indeed the logic)

Load.....

...

Left([CI 1],1) as Group,

...

From

And add the Group Dimension in your table or without the load in the Gui, add a calculated dimension

=Left([CI 1],1)

[#4]

Thanks for your quik repoonse,

I dont understand very well, in my load script i have only the name of fields that i loaded from my excel file.

the title of the table as unknow on my load script or calculated dimension. Do i have to declare "CI 1" before?

like u see im a real beginner on qlik, thanks you

[#5]

Thanks Piet Hein Van der Stigchel  for your answer

So i have to put that on the load script before i create the straight table itself?

[Anonymous · Accepted solution]

Hi

In you table add calculed Dimension

= left([CI 1],1)

[stigchel]

Yes, in your load script where you load the excel, just add an extra line as I said above

Load.....

...

[CI 1],

Left([CI 1],1) as Group,

...

From...

And do a reload, after that add the Group Dimension to your table

[fvelascog72]

Hi again,

I think you can add in script:

A1+A2          as "A",

B1+B2          as "B"

[#9]

Thanks everybody, i try your solution but it seem that i miss something, so here the exact straight table and the

result i get when i put left(...) or purgechar(...) on the calculated dimension script. thnx u guys

[MayilVahanan]

Hi

Are you need to combine Longueur 1 and Longueur 2 into Longueur?

If so, then what about Code and Pariticipation.

Could you able to explain ur exact requirement?