Need some help making groups

[Anonymous]

Dear specialists,

I am trying to make a group ID (or something else) in the loading script.

I have data like in the atteched Excel file (test.xl).

In the first column I have the row ID,

In the second an Level ID

in the third some test data.

As you can see I only have data when the Level ID = 0

Level ID's 1, 2 and 3 are (sub) Totals.

What would be the best way to group my ID's so I can use a Sum at my sub level ID's?

I also add an extra Excel file to clearify how the levels work (result.txt)

[nagaiank]

One example of doing this is in the attached qvw file. There may be simpler ways also.

Hope this helps.

[Anonymous]

Thanks that works for me!

[Anonymous]

Is there a way to use the ID's as name for the group/level?

[nagaiank]

I am not sure if I am understanding your question.

If ID to name mapping is unique, you can use name in the place of ID.

If the mapping is not unique and if ID field has only numeric values, you can define ID as dual field with numeric value as the number representation and name as text representation. Use number representation in chart expressions and text represenation in display.

I may be able to help you better, if you are more specific.

[Anonymous]

Sorry, you are right, I am not making sence.

What i want is to use the names of the level ID's in the Total row.

[Anonymous]

Does anybody have another solution from making these groups/levels?

The offert solution by krishnamoorthy does work but I need the names/numbers of the ID's in my total label.

http://community.qlik.com/message/135487#135487