Design esthetic problem

[#1]

Hello everybody,

i have a new problem to solve, Now is about design i want to categorize my filed, here is an example

I have all this filed already in my qlikview app Total, Boucle 1.. Boucle 3,

I want just for esthetic purpose to have that

So i want to create a "Boucle" case at the left to regroup ''Total + Boucle 1 +Boucle 2 + Boucle 3" and the line at the top ''Longueur"

somebody can help? Thanks

[petter]

You need to change the:

SubField(TOTAL, ' ' , 1)

so that the ' ' is replaced with a character the divides the TOTAL in two like for instance a period:

SubField(TOTAL, '.' , 1)

[sunilkumarqv]

Please close this thread making correct answer if you done .

[#4]

I dont resolve the problem, this why the discussion still open,

I create a qv file wiich containt already a field Boucle 1...3. can you can do it with that?

Because i seem like i dont explain very well, i dont want to insert manualy the values of the filed Boucle 1, 2 and 3, i have already load that in my qv app before.

Thanks !

[petter]

Is this what you are trying to achieve?

Here is a solution with either Straight Table or with Pivot Table.

[#6]

Big Thanks Petter,

But I missed something, in my example its was two fields = (Boucle 1, Boucle 2, boucle 3) and that containt value, but i fact its 3 fields : [Boucle 1], [Bo...

now i want to regroup like you did this 3 separates fields because its the same category

here is a new qv file

thanks

[sunilkumarqv]

Please find the attached

[#8]

Thanks Sunil, its almost done !

But like i say i want to do that for esthetic purpose so , how i can have at the left Just one Big  case Boucle instead of 3 separate cases?

[sunilkumarqv · Accepted solution]

Get attached

[#10]

Thanks You Sunil,

Just for perfection, i can do this with 'Longueur' case to at the top? i saw that you created 3 case for that too