App Development

[modernnonamad]

Hello all,

Based on below table, I would like to create a "Filter Pane" in QlikSense, which only show the Trainers' Name (Robert, Amy, John and Paul). May anyone help please?

Thank you very much.

TypeArea	TypeName	Sequence
Trainer	Robert	1
Trainer	Amy	1
Trainer	John	0
Trainer	Paul	0
Employee	Jack	3
Employee	Ada	4
Employee	Kim	5
Employee	Lion	5
Employee	Leo	3

[sunny_talwar · Accepted solution]

May be this

Aggr(Only({<TypeArea = {'Trainer'}>} TypeName), TypeName)

or this

If(TypeArea = 'Trainer', TypeName)

[modernnonamad]

Thank you very much Sunny. I modified your statement to the below and the result was PERFECT!!

Merry Christmas to you and your loved one!

if(TypeArea='Trainer'and (Sequence='0'or Sequence='1'),TypeName)

[sunny_talwar]

Thanks my friend, wish you a very happy holidays as well!!