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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
user-azadi
Contributor III
Contributor III

condition in Table in qlik sense

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:

UserIdNameSale
1001User1300
1002User2450
1003User3700

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

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.

View solution in original post

2 Replies
Anonymous
Not applicable

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
Contributor III
Contributor III
Author

Simple Answer but Important.

thanks dear Bill...