Qlik Sense Concat funtion in Straight table

[Gowtham]

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

[asinha1991]

if you want to split it why are you doing concat?

this doesn't work (as dimension)?

if(Type='$(=$(vType))' and  HospiceCharge=$(=$(vCharge)),Medication )

[Gowtham]

Can I Know How to exclude Selected medication from the filter with this same expression
if(Type='$(=$(vType))' and HospiceCharge=$(=$(vCharge)),Medication )

Thanks

[asinha1991]

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)

[Gowtham]

Hi Asinha,

Both the expressions are not working in the straight table.

Thank you

[asinha1991]

you tried as dimension ? it wont work as measure

[Gowtham]

Yes I tried as a dimension only

Thanks