topic Re: Qlik Sense Concat funtion in Straight table in App Development

Qlik Sense Concat funtion in Straight table

Gowtham — Fri, 27 Sep 2019 09:27:37 GMT

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

Re: Qlik Sense Concat funtion in Straight table

asinha1991 — Fri, 27 Sep 2019 09:41:53 GMT

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

this doesn't work (as dimension)?

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

Re: Qlik Sense Concat funtion in Straight table

Gowtham — Fri, 27 Sep 2019 09:47:38 GMT

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

Thanks

Re: Qlik Sense Concat funtion in Straight table

asinha1991 — Fri, 27 Sep 2019 09:53:47 GMT

if you want to exclude selected value maybe do this(in dimension)

aggr(only( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication ),Medication)

aggr(MaxString( Distinct {<Medication= , Type={'$(=$(vType))'}, HospiceCharge={"<$(=$(vCharge))"} >} Medication ),Medication)

Re: Qlik Sense Concat funtion in Straight table

Gowtham — Fri, 27 Sep 2019 10:04:26 GMT

Hi Asinha,

Both the expressions are not working in the straight table.

Thank you

Re: Qlik Sense Concat funtion in Straight table

asinha1991 — Fri, 27 Sep 2019 10:23:00 GMT

you tried as dimension ? it wont work as measure

Re: Qlik Sense Concat funtion in Straight table

Gowtham — Fri, 27 Sep 2019 10:24:08 GMT

Yes I tried as a dimension only

Thanks