Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to exclude these two string values using the button. I was trying to use this expression but its not working.
"("& concat({<ServiceOrderDesc-={"SPARE PARTS ORDER","spare part needed"}>} Distinct ServiceOrderDesc, '|')& ")'
Its not working. Anyone help me please!
Here is the sample off my data.
If you have an app to share i can apply the same to yours.
try this
='(' & Concat( {<ServiceOrderDesc=-{'SPARE PARTS ORDER','spare part needed'}>} distinct '"' & ServiceOrderDesc & '"','|') & ')'
it will create values like this:
("Value1","Value2")
..excluding the 2 you wrote out
The double quotes are used in case their are spaces or other special characters in the Values
Hey Jonathan,
I appreciate your help but its not working.
Thanks,
Shan
Oh thats ok. The expression editor has a bug on the highlighter when you use -= syntax in SET ANALYSIS. You'll notice it says 'ok' right above. Trying hitting OK and let me know the results.
It still doesnt work.
Thanks,
Shan
Here is the sample off my data.
If you have an app to share i can apply the same to yours.
Jonathan,
Thank you very much. Its working now.
Shan
Sorry, I was using an excel file and it was working but now i am using database and its not working now.
Thanks,
Shan