Need help for an expression

[ananyaghosh]

Hi,

For the fllowing expression;

if ([Product Type Code] = 'IN', 'MF', 'LS', [Social Code Group] = 'RET','DCIO','Non-DCIO')

I have used in an dimension for the condition is that: if the product type code is in 'IN', 'MF', 'LS', then [Social Code Group] field values will be in 'RET','DCIO','Non-DCIO'.

Please give me the correct syntax of expression for the above condition.

Thanks,

Sandip

[hemanthaanichet]

Hi Sandip,

Your requirement is whenever [Product Type Code]=IN,MF,LS then [Social Code Group] = RET,DCIO,Non-DCIO

so you can use pick and match in your expression

match([Product Type Code], 'IN', 'MF', 'LS') which fetch IN, MF, LS

It will perform whenever IN MF LS comes RET DCIO Non-DCIO will appear

Try this:

pick(match([Product Type Code], 'IN', 'MF', 'LS'), 'RET','DCIO','Non-DCIO')

or

May this i think so:

if (match([Product Type Code], 'IN', 'MF', 'LS'),match([Social Code Group] , 'RET','DCIO','Non-DCIO'),[Social Code Group])

Regards

Hemanth

[hemanthaanichet]

Hi Sandip

I tired with sample data

pick and match expression is working fine

if statement is not upto desired

Attached a qvw for the reference

Regards

Hemanth