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 for collaboration related to QlikView App Development.
I am trying to show the combinations only in the below screenshot. But I am getting the individual Product names also. Please help to advise how to exclude the same.
Code used in the calculated Dimension: =aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID)
where Blue highlighted values are individual product name that I don't want to show and Red colored value is the one I want to show.
Please let me know if any other details required.
Thanks in advance.
Thanks a lot for your time and reply.
However, when I tried the above code, I am getting "Allocation Memory exceeded" Error. Any idea why we getting this error in Calculated Dimension. But I am able to proceed with above code in my reply.
Thanks and Regards,
View solution in original post
I am able to remove the Individual Product name using WildMatch() as all the combinations having '+' sign.
Code:=If(Wildmatch(aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID),'*+*')=1,aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID))
if(count(Aggr(Distinct ProductName,OrderId))>1,aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID))