Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Does anyone know how to use selected field value and do a wildcard search in Chart "Sort by expression"
I tried this
if (GetCurrentSelections(Roadway) like '*Eastbound', milemarker, -milemarker)
During test, the chart continue loading after select a roadway without showing any result
Is the above expression correct? How do I fix it?
Please advise
Regards
try this.
=if(Roadway like '*Eastbound' or Roadway like 'milemarker' or Roadway like '-milemarker',1,0)
1,0 -> your conditions
try this.
=if(Roadway like '*Eastbound' or Roadway like 'milemarker' or Roadway like '-milemarker',1,0)
1,0 -> your conditions
thank a lot. it works. why just use field name instead of the selected filed value
Welcome Cheng Ma,
You can also use getCurrenSelection or getFieldSelection.
Ex: =if(GetCurrentSelections(Roadway) like '*Eastbound' or GetCurrentSelections(Roadway) like 'milemarker' or GetCurrentSelections(Roadway) like '-milemarker',1,0)