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.

[its_anandrjs · Accepted solution]

Try to check the spellings of the Gillet and oldSpice in the field Product or may be you can use if condition as calculated dimension that i suggest or you can use WildMatch also here.

can you provide the list of Product field items for look out.

Regards

Anand

[kaushiknsolanki]

Sorry missed one quote

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

[Chanty4u]

u just remove as newfield

[avinashelite]

Try like this

=if(Match(upper(Product),'GILLET' ,'OLDSPICE'),Product)

this should work

[Chanty4u]

try this too

=if ( wildMatch(upper(Product), '*GILLET*') and wildmatch(upper(Product), '*OLDSPICE*' ),'Product')

[sasikanth]

hi,

If the values are fixed you can try this way

Calculated Dimension:

pick (WildMatch( upper(Product), '*GILLET*', '*OLDSPICE*'),'Gillet', 'oldSpice')

Check the option suppress NULL values