topic Re: How to compare two columns in same table? in Archived Groups

How to compare two columns in same table?

Wed, 23 Jul 2025 14:48:52 GMT

Hi,

I have two column in same table like,TEAM_A and TEAM_B.I have joined in these two columns into one column as TOTAL_TEAM and COUNTRIES.Now i want to remove the selected value of COUNTRIES in TOTAL_TEAM column.For Example if i click 'india' in COUNTRIES,it should be only show the five counties name from TOTAL_TEAM with out the value of 'india',because india played only 5 match,Based on the Match_ID.

Re: How to compare two columns in same table?

sunny_talwar — Fri, 27 Jan 2017 10:33:23 GMT

May be use calculated expression for your list box for TOTAL_TEAM

Aggr(If(GetSelectedCount(COUNTRIES) = 0, Only({1} TOTAL_TEAM), Only{1<TOTAL_TEAM = e(COUNTRIES)>} TOTAL_TEAM), TOTAL_TEAM)

Re: How to compare two columns in same table?

Fri, 27 Jan 2017 10:51:01 GMT

Thanks for reply Sunny T, I got some error in this Expression like below,

Re: How to compare two columns in same table?

sunny_talwar — Fri, 27 Jan 2017 10:57:28 GMT

Does it not work when you click ok?

Re: How to compare two columns in same table?

Fri, 27 Jan 2017 11:07:26 GMT

Thanks Sunny Now it's work.Is it possible for load script?

Re: How to compare two columns in same table?

sunny_talwar — Fri, 27 Jan 2017 11:56:53 GMT

Isn't this based on selection? Are you planning to reload data after making selection in Country field?

Re: How to compare two columns in same table?

Fri, 27 Jan 2017 12:35:16 GMT

I have planned to use this Total_Team field into chart objects.How to use this column in Dimension Field. Aggr function is not convenience to Calculated Dimension.

Re: How to compare two columns in same table?

sunny_talwar — Fri, 27 Jan 2017 12:42:49 GMT

You should incorporate the same logic in set analysis of your expression instead of using a calculated dimension.... something along these lines I guess

If(GetSelectedCount(COUNTRIES) = 0, Sum(Measure), Sum{<TOTAL_TEAM = e(COUNTRIES)>} Measure))

With TOTAL_TEAM as your dimension

Re: How to compare two columns in same table?

Fri, 27 Jan 2017 13:07:29 GMT

The result of the TOTAL_TEAM field may having a duplicate record. Aggregator function can remove the duplicates rows in chart objects due to associate with other dimensions.can you have anything else for this?

Re: How to compare two columns in same table?

sunny_talwar — Fri, 27 Jan 2017 13:26:20 GMT

Do you have a sample you can share?

Re: How to compare two columns in same table?

Fri, 27 Jan 2017 13:47:36 GMT

i have used one straight table with one dimension and one expression,

Dimension =Aggr(If(GetSelectedCount(COUNTRIES) = 0, Only({1} TOTAL_TEAM), Only({1<TOTAL_TEAM = e(COUNTRIES)>} TOTAL_TEAM)), TOTAL_TEAM)

Expression=Match_ID

If i click the 'west indies' of Country field,it shown only 4 values.but 'west indies' played 6 match,the result is given below,