Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
snarrp_Rocky
Contributor III
Contributor III

Shortling Dimension


Need urgent help please.

How can I select only selected names in the dimension.

That is, I have below data, in that I need to select only Ram, Rakesh, Pooja and Ganesh.

 

NOTE: I need to achieve this from expression please not with script.

Ram
Rahul
Rakesh
Pooja
Mohan
Ganesh
Mahesh


Your name is greatly Appreciated.

Best Regards

6 Replies
sergio0592
Specialist III
Specialist III

Hi,

Try with :

if(match(Your_dim,'Ram','Rakesh','Pooja','Ganesh'),Your_dim)
Vegar
Partner
Partner

You can create a ListBox with an expression instead of an dimension like in the picture below.

image.png

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
snarrp_Rocky
Contributor III
Contributor III
Author

##-actually I need to do this in straight table -##
Sent from Yahoo Mail on Android
olivetwist
Creator
Creator

See Attached

stigchel
Partner
Partner

As your dimension

=Aggr(Only({<FieldName={'Ram','Rakesh','Pooja','Ganesh'}>} Fieldname),FieldName)

Brett_Bleess
Support (Former)
Support (Former)

Please use the Accept as Solution button on any of the posts that helped solve your question, if you are still needing assistance, provide further details, and if you resolved it on your own, please share what you did and then mark that reply as the solution as well.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.