Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need some help making groups

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)

6 Replies
nagaiank
Specialist III
Specialist III

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

Hope this helps.

Anonymous
Not applicable
Author

Thanks that works for me!

Anonymous
Not applicable
Author

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

nagaiank
Specialist III
Specialist III

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
Not applicable
Author

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
Not applicable
Author

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