topic Re: Exclude unwanted values from calculated dimension in QlikView

Exclude unwanted values from calculated dimension

arockiyaselvana — Tue, 03 Feb 2015 08:03:45 GMT

Hi all,

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.

- Arockiya

Re: Exclude unwanted values from calculated dimension

arockiyaselvana — Tue, 03 Feb 2015 11:09:34 GMT

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))

Re: Exclude unwanted values from calculated dimension

PrashantSangle — Tue, 03 Feb 2015 11:28:31 GMT

Hi,

Try like

if(count(Aggr(Distinct ProductName,OrderId))>1,aggr(Concat(DISTINCT ProductName,'+',ProductName), OrderID))

Regards

Re: Exclude unwanted values from calculated dimension

arockiyaselvana — Tue, 03 Feb 2015 11:43:15 GMT

Hi Max,

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,

Arockiya