This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a requirement to concat two fields to show in a pivot table.
Week, Category, title
Kindly help me with the concat function
Shruthi B K
You can try this
=Concat(DISTINCT Aggr(Concat(DISTINCT title, ',') & '(' & Category & ')', Week, Category), ',')
View solution in original post
Use something like the following as expression:
Concat(Distinct title & '(' & Category & ')')
the expression doesn't return the desired output
the suggested expression is giving the output
but expected output is
What is the O/P you need from below table?
for week 1
Thank you Sunny 🙂
But this doesn't seem to work with the solution you provided to @Anil_Babu_Samineni updated sample.
you can try this, it's work.
=Concat(DISTINCT Aggr(Concat(DISTINCT title, ',') & '(' & Concat(DISTINCT Category,',') & ')', Week, Category), ',')