Dimension

[smilingjohn]

HI All ,

In the bar chart Under dimension  from Product Field i want to displace only two products Resistivity and sensitivty

Please let me know if iam using correct formula ?

=if(Match(Product,'Gillet' ,'oldSpice'),Product)

for the above expression iam geting only Gillet but not oldspice.

[kaushiknsolanki]

Hi

Try wildmatch function instead of match.

Also include * before and after value

Regards,

Kaushik solanki

[Chanty4u]

=if(WildMatch(Product, '*Gillet*', '*oldSpice*'), 'product') as NewField

[smilingjohn]

Iam trying this under dimension  of bar chart .

So i think i cannot use AS

[its_anandrjs]

Hi,

Your expression is correct

=if(Match(Product,'Gillet' ,'oldSpice'),Product)

You can try this also

=if(Product = 'Gillet' , 'Gillet',

if(Product = 'oldSpice' , 'oldSpice'))

And use suppress when value is null

Regards

Anand

[Chanty4u]

yes u can create a flag in back end and u can get directly..

[smilingjohn]

Hi Kaushik,

Iam trying to use this in a bar chart under Dimensions "Add Calculated Dimension" ?so how do i use

[smilingjohn]

Hi Anand thanks for your reply

I tried your expression too but yet its diplaying only Gillete , its not displaying both

Actually ther are 7 productins in that field out of which i want to display only 2 products in the bar graph

[Kushal_Chawda]

try this

if(Match(lower(trim(Product)),'gillet' ,'oldspice'),Product)

[kaushiknsolanki]

Try this way,

=if(wildMatch(Product,'*Gillet*' ,'*oldSpice*),Product)

Regards,

Kaushik solanki