Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to do a listagg in Qlik Sense? Or whatever the equivalent is to listagg in pl/sql...
A similar question was asked a while back but I can't get it to work for me.
You need to use the above as an expression or use it like this for calculated dimension
Aggr(Concat(FieldName, '/', FieldName2), <DimensionNameHere>)
Replace DimensionNameHere with the dimension with the dimension over which you want to Concat FieldName.
I think you need Concat() function
Hi Jana,
You can achieve this with the help of concatenate() function. but I think no such a function in Qlikview or Qliksense.
Thanks,
Arvind
HI Jana,
Please find attachment may be it will serve your purpose.
Thanks,
Arvind Patil
This is good for Qlik View, but we are using Qlik Sense. Is there something comparable?
Concat works in QlikView and Qlik Sense
Make sure to check this link
I'm sorry, I'm brand new to this....
So if i only have one field i need to see, and it needs to show in succession for as many times as it shows in the table, i just use concat([field name])? I don't need the distinct, and i can't figure out how to set the delimeter, this will just be '/'
If i decided on a sort weight, do i just list that field in the last piece? and is this syntax accurate?
CONCAT9[field name] , [, '/' [ filed name2]])
Something like this
Concat(FieldName, '/', FieldName2)
For Distinct
Concat(DISTINCT FieldName, '/', FieldName2)
This is getting close, it’s accepting the formula. It still says it’s an invalid dimension, however. I’ll keep playing with this. Thank you.