Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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)
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.
=if({<road='o1-pasteR','02-PasteR','03-PasteR', Paste) ,null()
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 .
Hi John,
You can use if(WildMatch(Road,'*paste*'),Road) in the dimension and check the suppress when value is null in dimension tab.
Hi
Try like this
Dimension
Road
Expression
SUM({<Road = {'*PASTE*'}>}investment)
sorry mistake from me
if (match(upper(Road), 'PASTE' > 0, Road)