Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is my expression
Concat( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication , ',' )
I want to use this expression in straight table and I need to know how to split the comma separated column values to multiple rows
Please help me?
Thanks
if you want to split it why are you doing concat?
this doesn't work (as dimension)?
if(Type='$(=$(vType))' and HospiceCharge=$(=$(vCharge)),Medication )
if you want to exclude selected value maybe do this(in dimension)
aggr(only( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication ),Medication)
or
aggr(MaxString( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication ),Medication)
Hi Asinha,
Both the expressions are not working in the straight table.
Thank you
you tried as dimension ? it wont work as measure
Yes I tried as a dimension only
Thanks