Discussion Board for collaboration related to QlikView App Development.
I have a requirement here i have to show top 2 and bottom 5 dimensions in two separate tables but i also need to show the count of those dimensions in variables (should be dynamic).
Can anyone please help me to achieve this ?
PFA for example.
Solved! Go to Solution.
I'm afraid I don't understand. The top 2 is always 2 items. Why do you need a variable for that?
Or do you want to choose dynamically how many items should be shown in a Top X? In that use the variable for both purposes, to set the limit on the Dimension Limits tab and to show the limit value in the text object. Same for the Bottom Y.
You could use slider objects to allow the user to change the values of the variables.
You can find an example here: https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Slider-to-Display-Top-n-Entities/ta-p/...
Should the text box show the number 2 when the table shows the Top 2? Yes
Should the text box show the number 5 when the table shows the Top 5? Yes
Should the user be able to change the value of the variable from one number to another number? If the user select just one dimension in the table then the variable value should show 1.
If the user select just one dimension in the table then the variable value should show 1.
Do you mean dimension value instead of dimension?
For example: Country is a dimension and France, Belgium and Ireland are dimension values of the Country dimension.
Perhaps you want your variable to count the dimension values: =count(distinct MyDimension)