OK - let me see what we can do.
Do you have QlikView Personal as well?
if not you can get it here: BI Platform Free Download, QlikView Personal Edition | Qlik
Note that QlikView and Sense are two different products that can address similar and different use cases.
I can get into more detail about this if needed, in the mean-time you may want to check out this blog post:
I'll come back to you shortly.
For Qlik Sense version 0.96, here's a work-around that I did for one of my personal apps. I've created a data island in my script by using the INLINE command. This inline table has only one field and I gave it three values: 25, 50, and 100. For the measures in the user interface, I added an IF statement where the original expression will only calculate if the RANK of the expression is <= the MAX of the inline table value (25, 50, 100). For false values, I gave the measure a null. Finally, I added a filter pane that has the three values displayed so users can select the top 25, 50, or 100 rows. Try it out!
Hi Ashley - try this sample attached:
- Copy to: C:\Users\<user>\Documents\Qlik\Sense\Apps
- Start Sense Desktop
Let me know if this is the functionality you are looking for. However there isn't a slide yet to control the values. I used a listbox with the value. That could be done with an extension object though.
Note in the table object in the columns, there is a Limitation option, you can choose a fixed value - or make it equal to an expression. I simply chose to make it equal to the value that is selected in the listbox by using the TopValue field name from the inline table and sort the table object by the sales value descending.
The inline table is defined in the load script - you can use the Data Load Editor to view and modify that in our example.
Note: I did not include the sample data - so loading this app again will fail.
Please let me know if this is close to what you were thinking.
Top Parameter.qvf 640.0 K
The below should work, add a text object and add an action to Select in Field SalesPerson and add the following expression
='(' & CONCAT(IF(AGGR(RANK(Sum(Sales)),SalesPerson) <= 25,SalesPerson),'|') & ')'
In this case I am assuming your Metric is Sales and Dimension is SalesPerson
Hope it helps