topic Re: dimension grouping in QlikView

dimension grouping

Tue, 11 Mar 2014 10:13:56 GMT

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-

Re: dimension grouping

Tue, 11 Mar 2014 10:20:46 GMT

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

Re: dimension grouping

Tue, 11 Mar 2014 10:26:30 GMT

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.

Re: dimension grouping

sudeepkm — Tue, 11 Mar 2014 10:40:59 GMT

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)

Re: dimension grouping

Tue, 11 Mar 2014 11:15:07 GMT

Thanks, Mario, that helped me to solve the problem

;pauli-

Re: Re: dimension grouping

sunilkumarqv — Tue, 11 Mar 2014 11:31:04 GMT

Like these see attached

Thanks

Re: Re: dimension grouping

Tue, 11 Mar 2014 11:42:41 GMT

thanks Roland, I used this one.

;pauli-