Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

user-azadi
New 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

Re: condition in filter pane in qlik sense

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.

2 Replies

Re: condition in filter pane in qlik sense

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

Re: condition in Table in qlik sense

Simple Answer but Important.

thanks dear Bill...

Community Browser