topic Re: Dynamic Count? in QlikView

Dynamic Count?

qlikuser222 — Sat, 16 Nov 2024 21:48:55 GMT

Hi Everyone,

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.

Thanks

Re: Dynamic Count?

Gysbert_Wassenaar — Wed, 28 Nov 2018 17:20:29 GMT

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/1486875

Re: Dynamic Count?

qlikuser222 — Wed, 28 Nov 2018 17:20:55 GMT

Thanks for the reply,

I want to create a text box with a variable showing top 2 and other one with bottom 5 and they should be dynamic.

Thanks

Re: Dynamic Count?

Gysbert_Wassenaar — Wed, 28 Nov 2018 17:23:22 GMT

Let's try that again. Please answer yes or no only to the following questions:
Should the text box show the number 2 when the table shows the Top 2?
Should the text box show the number 5 when the table shows the Top 5?
Should the user be able to change the value of the variable from one number to another number?

Re: Dynamic Count?

qlikuser222 — Wed, 28 Nov 2018 17:34:11 GMT

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.

Re: Dynamic Count?

Gysbert_Wassenaar — Wed, 28 Nov 2018 17:38:54 GMT

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)

Re: Dynamic Count?

qlikuser222 — Wed, 28 Nov 2018 17:42:19 GMT

Like without any selections the text box should show count of 2. ( Possible count of that dimension is 7).

Can we use rank or some function to achieve this?

Re: Dynamic Count?

Gysbert_Wassenaar — Wed, 28 Nov 2018 17:52:26 GMT

Perhaps this: =rangemin(2, count(distinct MyDimension))