Custom Group for Data Elements

Fri, 25 Feb 2011 13:04:53 GMT

Dear Gurus,

Is there a way to group data elements via an expression. Example:

I have a report that looks like this

1. iPhone $500

2. Blackberry $125

3. iPAD $300

I would like to add another row that groups iPhone and iPad so whatever calculations i add into the report, it will always add those two values up. Becomes something like below

1. iPhone $500

2. Blackberry $125

3. iPAD $300

4. iPhone&iPad $800

It is some sort of custom grouping at the data element side, is this possible in QlikView? Some other vendors such as MicroStrategy allows the user to create a custom group and you can 'add' elements and group them up and this group can be used as a dimension.

Appreciate any help and thank you very much

Custom Group for Data Elements

johnw — Fri, 25 Feb 2011 23:31:39 GMT

I don't think you can group them with an expression, but you can group them using script. Let's say that your field is "Item". Create a new field, "ItemGroup", that includes all items AND any groupings of items you also want to see.

[ItemGroups]:
LOAD
Item as ItemGroup
,Item
;
LOAD text(fieldvalue('Item',iterno())) as Item
AUTOGENERATE 1
WHILE len(fieldvalue('Item',iterno()))
;
CONCATENATE ([ItemGroups])
LOAD * INLINE [
ItemGroup, Item
iPhone&iPad,iPhone
iPhone&iPad,iPad
];

Now use ItemGroup as the dimension, and QlikView's associative logic will pick up the right data to handle the group totals.

topic Custom Group for Data Elements in QlikView

Custom Group for Data Elements

Custom Group for Data Elements