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.
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.
