condition in Table in qlik sense

[user-azadi]

hello experts;

i have below tables

TableUser:

load * inline [

UserID, Name

1001, User1

1002, User2

1003, User3

];

TableSales:

load * inline [

UserID, Sale

1001, 200

1001, 300

1001, 250

1002, 400

1002, 450

1003, 700

1003, 550

];

in qlik sense i want maketable with expression condition that show me UserID , Name and only Maximum of value Sales. same below:

UserId	Name	Sale
1001	User1	300
1002	User2	450
1003	User3	700

how can i do it , without make other table in data editor (only use expression in Table section)?

[Anonymous · Accepted solution]

You can make a table like what you wish, but it is not a filter pane although you can make selections by clicking it's dimensions - See attached.

[user-azadi]

Simple Answer but Important.

thanks dear Bill...