topic Re: Straight table group in QlikView

Straight table group

Wed, 03 Jun 2015 14:27:40 GMT

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

Re: Straight table group

fvelascog72 — Wed, 03 Jun 2015 14:35:23 GMT

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"

Re: Straight table group

stigchel — Wed, 03 Jun 2015 14:37:06 GMT

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)

Re: Straight table group

Wed, 03 Jun 2015 14:53:38 GMT

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

Re: Straight table group

Wed, 03 Jun 2015 14:59:24 GMT

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?

Re: Straight table group

Anonymous — Wed, 03 Jun 2015 15:01:28 GMT

In you table add calculed Dimension

= left([CI 1],1)

Re: Straight table group

stigchel — Wed, 03 Jun 2015 15:05:47 GMT

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

Re: Straight table group

fvelascog72 — Wed, 03 Jun 2015 15:29:07 GMT

Hi again,

I think you can add in script:

A1+A2 as "A",

B1+B2 as "B"

Re: Straight table group

Thu, 04 Jun 2015 07:14:57 GMT

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

Re: Straight table group

MayilVahanan — Thu, 04 Jun 2015 07:23:50 GMT

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?

Re: Straight table group

Thu, 04 Jun 2015 07:29:10 GMT

In fact i want to have like pivot table on big case Longueur at the left , and longeur 1 and longueur 2 for more details, i put the code dimension (that i hide in the presentation tab) because if i dont i'll not have a vertical table like this.

Hope that u understand, thnaks

Re: Straight table group

Thu, 04 Jun 2015 07:35:01 GMT

Other thing, the column at the left that i want to create is just for the presentation purpose (to group similar dimensions)

Thanks