Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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-
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
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
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
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)
Thanks, Mario, that helped me to solve the problem
;pauli-
Like these see attached
Thanks
thanks Roland, I used this one.
;pauli-