topic Filter Pane issue in App Development

Filter Pane issue

Anonymous — Thu, 21 Dec 2017 10:13:24 GMT

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

Re: Filter Pane issue

sunny_talwar — Thu, 21 Dec 2017 18:07:08 GMT

May be this

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

or this

If(TypeArea = 'Trainer', TypeName)

Re: Filter Pane issue

Anonymous — Sat, 23 Dec 2017 02:39:56 GMT

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)

Re: Filter Pane issue

sunny_talwar — Sun, 24 Dec 2017 00:05:22 GMT

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