topic Re: Qlik sense Only Function in App Development

Qlik sense Only Function

Gowtham — Thu, 12 Sep 2019 06:52:58 GMT

How to use Only() function to return multiple values with comma separated?

asinha1991 — Thu, 12 Sep 2019 07:00:34 GMT

if you want comma separated value use concat...

concat(Fieldname,',')

only is used when we have just one output, concat combines multiple output in one cell

Gowtham — Thu, 12 Sep 2019 07:10:36 GMT

Hi,

This is my expression

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

I want to show multiple medication in the KPI or text and I know only() return null when there is multiple values

Is there any alternative for Only() to show multiple values?

Thank you

tresB — Thu, 12 Sep 2019 07:20:15 GMT

As already suggested by Asinha, try like:

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

asinha1991 — Thu, 12 Sep 2019 07:21:55 GMT

try this

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

Gowtham — Thu, 12 Sep 2019 07:33:43 GMT

Thank you,

Its working as I expected

Gowtham — Thu, 12 Sep 2019 07:35:54 GMT

Thank you Ashinha,

It's working now