Regarding Renaming label of Expression by condition

[sarfaraz_sheikh]

Dear All,

In my pivot table ...i have two dimension(Branch_Name,and Process_Loc) and 2 expression(Inward,FTNR),

I want the label of Expression to be change for particular Dimesion.Kindly have the on belew screenshot.

In above screenshot only for FTNR% ....I want POS in label instead of Inward similarly i want NONPOS in place of FTNR label.

kindly help if possible. my QVW is also attached here for your refernce.

Sarfaraz

[PrashantSangle]

Hi,

USe conditional Dimension

Try like

if(wildmatch(Precess_Loc,'FTNR%'),'POS',if(wildmatch(Process_Loc,'FTNR','NONPOS',Process_Loc)))

Regards

[robert_mika]

Hi Max,

Has your formula been posted correctly?

I'm getting "Error in expression"...

[sarfaraz_sheikh]

Dear Max,

I want to change the label of expression 'Inward'  as POS for FTNR% .

Kindly help !!!

Sarfaraz

[PrashantSangle]

Hi,

Thanks.

I am missing Closing Bracket of second if

Try below

if(wildmatch(Precess_Loc,'FTNR%'),'POS',if(wildmatch(Process_Loc,'FTNR'),'NONPOS',Process_Loc))

Regards

[sarfaraz_sheikh]

Dear All,

I want the expression label to be changed only for particular dimension content.

Sarfaraz

[avinashelite]

Hi Sarfaraz,

To achieve this please follow the below steps:

1.In the script implement the this script.

LOAD BRANCH_NAME_DESC,

     if(Wildmatch(PROCESS_LOC,'POS'),'POS',if(WildMatch(PROCESS_LOC,'BRANCH','CENTRAL'),'NONPOS','FTNR%')) as PROCESS_LOC,

     SI_NO,

     DISP_CATEGORY

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Then in the Expression use this formula and no need to add the expression in the dimension directly add PROCESS_LOC as the dimension.

in expression label use this expression:

if(PROCESS_LOC='FTNR%','POS','Inward')

hope this helps you