Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham
Contributor III
Contributor III

Qlik Sense Concat funtion in Straight table

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

6 Replies
asinha1991
Creator III
Creator III

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
Contributor III
Contributor III
Author

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

Thanks
asinha1991
Creator III
Creator III

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
Contributor III
Contributor III
Author

Hi Asinha,

Both the expressions are not working in the straight table.

Thank you

asinha1991
Creator III
Creator III

you tried as dimension ? it wont work as measure

Gowtham
Contributor III
Contributor III
Author

Yes I tried as a dimension only

Thanks