topic Re: Shortling Dimension in QlikView

Shortling Dimension

snarrp_Rocky — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Shortling Dimension

sergio0592 — Thu, 11 Jul 2019 07:13:26 GMT

Hi,

Try with :

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

Re: Shortling Dimension

Vegar — Thu, 11 Jul 2019 07:20:47 GMT

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

Re: Shortling Dimension

snarrp_Rocky — Thu, 11 Jul 2019 12:50:03 GMT

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

Re: Shortling Dimension

olivetwist — Thu, 11 Jul 2019 13:02:21 GMT

See Attached

Re: Shortling Dimension

stigchel — Thu, 11 Jul 2019 13:11:47 GMT

As your dimension

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

Re: Shortling Dimension

Brett_Bleess — Thu, 01 Aug 2019 14:43:21 GMT

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