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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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