Dimension

[smilingjohn]

Hi ALl

Ther is a field name called "Road" under which we have the data like

Tar road

Damber road

Cement road

Concrate road

01-pasteR

02-PasteR

03-PasteR

Paste-Rd

paste-Tr

Elevator road

Crane road

06-PasteR

Railway road

.

.

.

.; and so on

I am having a bar chart where iam showing the investment of by road with different condition in the expression.

Can some one tell me how to take  a dimention "Road"  and it should show only Paste types like o1-Paste road, 02-Paste road and so on

it should show only paste roads , How do we get this .

As of now iam taking dimension as "Road"  and the expresson .

But under dimension i want to show only Paste roads of "Road" 

Thanks in Advance

[Anonymous]

try calculated dimension

if (Match(Road,'Paste'>0, Road,null()) will test for occurence of "Paste" in Dimension Road and if so, will Show value

[MK_QSL · Accepted solution]

By Calculated Dimension

Dimension

=IF(WildMatch(Upper(Road),'*PASTE*'),Road)

Tick Suppress When Value is Null

Expression

SUM(investment)

By Set Analysis

Dimension

Road

Expression

SUM({<Road = {'*PASTE*'}>}investment)

[sunny_talwar]

May be use a calculated dimension:

If(WildMatch(Upper(Road), '*PASTE*'), Road)

and then select 'Suppress When Value Is Null' option on the dimension tab.

Alternatively you can create a new dimension in your script:

If(WildMatch(Upper(Road), '*PASTE*'), Road) as PasteRoad

and use this in your chart which I think would be a better option then created a calculated dimension.

[Chanty4u]

=if({<road='o1-pasteR','02-PasteR','03-PasteR', Paste) ,null()

[smilingjohn]

Hi Rudolf

This expression is not working

I need to have aal those which has the paste roads , wheteher it has in beginig numbers and then paste road or after paste roads as something .

It shoul show me everything thats has paste roads .

[#7]

Hi John,

You can use if(WildMatch(Road,'*paste*'),Road) in the dimension and check the suppress when value is null in dimension tab.

[MayilVahanan]

Hi

Try like this

Dimension

Road

Expression

SUM({<Road = {'*PASTE*'}>}investment)

[Anonymous]

sorry mistake from me

if (match(upper(Road), 'PASTE' > 0, Road)