Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
rustyfishbones
Honored Contributor II

Select in Field Expression

Hi All,

I have created a button with an action to Select in Field to get the top 10 files by Size

2014-08-08_0827.png

I have the following Expression

SUM({<[Full Path] = {"=Rank(SUM(Size))<=10"}>}Size)

Any thoughts

1 Reply
Not applicable

Re: Select in Field Expression

Hi,

Please find the attached QVW for sample Application

What you can do is

create one variable for example vTop10 and set an action in button to set that variable like this

= if(vTop10<>10,10,count(File))

and another action for toggle select

and use the dimension Limit tab of chart and Check Show only largest  and give variable in the expression as $(vTop10)

Thanks and Regards,

Vivek