Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)?
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.
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.
Simple Answer but Important.
thanks dear Bill...