topic Grouping Dimensions in QlikView

Grouping Dimensions

Sun, 29 Mar 2015 00:16:05 GMT

I have 4 dimensions in my main table that I need to group.

1. Apple

2. mango

3. Pineapple

4. Banana.

I need to group all of these as "fruits". How do i do it in the scrpit?

Anonymous — Sun, 29 Mar 2015 00:21:30 GMT

Have you looked into the CrossTable() function?

Sun, 29 Mar 2015 00:33:33 GMT

I have but I cant seem to work my way around on this. Are you ok to provide some guidance?

Anonymous — Sun, 29 Mar 2015 00:41:54 GMT

In the script:

if(wildmatch(YourFieldName, '*apple', 'mango', 'banana'), 'Fruit', YourFieldName) as YourNewFieldName

(Here *apple covers both apple and pineapple)