Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to compare two columns in same table?

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.

tt.JPG

Labels (2)
10 Replies
Not applicable
Author

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,rr.JPG