dimension grouping

[#1]

I have just started as a qv user and need some help.

I have a straight table which has dimension MainGroup that has values A,B,C1,C2,D and E. I want to group rows C1 and C2 together, putting them together as C. I need to have C1 and C2 elsewhere in the application.

Thanks.

;pauli-

[#2]

Create a new field in the load script like this:

Load MainGroup ,

if( match(MainGroup,'C1','C2'), 'C',MainGroup) as MainGroupCustom

from....

Hope this Helps

MC

[#3 · Accepted solution]

Hi,

you can create a calculated dimension in the chart instead of the existing like z´this:

=if(MainGroup = 'C1' or MainGroup= 'C2', 'C', MainGroup)

In the rest of your app you can use MainGroup normally.

RR

[sudeepkm]

You may use wildmatch() so that if the value starts with C (like C1, C2, C3) then it will be grouped as C.

You can use the below expression as your dimension.

=if(wildMatch(MainGroup,'C*')>0,'C',MainGroup)

[#5]

Thanks, Mario, that helped me to solve the problem

;pauli-

[sunilkumarqv]

Like these see attached

Thanks

[#7]

thanks Roland, I used this one.

;pauli-