Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

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)

Tags (2)
6 Replies
nagaiank
Valued Contributor III

Re: Need some help making groups

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

Hope this helps.

Partner
Partner

Re: Need some help making groups

Thanks that works for me!

Partner
Partner

Re: Need some help making groups

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

nagaiank
Valued Contributor III

Re: Need some help making groups

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.

Highlighted
Partner
Partner

Re: Need some help making groups

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.

Partner
Partner

Re: Need some help making groups

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