Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sadabala_bi
New Contributor II

How to make our chart dynamically change based on the customized field Top(5,10,15)

Hi,

Top.png

Here I am creating a new Dimension by giving the expression  $(vTop)

Here vTop is the variable having the expression  valueList(5,10,15).



Kind Regards.

1 Solution

Accepted Solutions
sadabala_bi
New Contributor II

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

HI,

Here is the solution for this.

1).Download the variable extension from https://github.com/erikwett/qsVariable/raw/master/dist/variable.zip and extract       to extensions folder of Qlik Sense. The variable extension is visible in the charts tab as shown in below image. and         choose Render as field from and give name as vTop save it and use vTop in your above expression for the specific         measure to be used in the chart or table...

q.png

2).Drag and drop the extension to the work pane.

3).Before that create a variable(here vTop is my variable).

q1.png

4) Give this name reference to the variable extension Field.

q2.png

5)Now write the expression of measure using the variable "vTop" like

Sum({<Dealer = {"=rank(sum(support_count))<= $(vTop)"}>}support_count)

6)now we can see the Top values based on the entered value.

q3.png

Thanks,

Sattipandu.

6 Replies
shwetagupta
Contributor

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

Hi Sattipandu Adabala,

If i am not getting your question wrong you want to limit dimension on the basis of top 5, 10 or 15 measures.

This is what are you asking ?

ramoncova06
Valued Contributor III

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

you need to use a key field but this should work

sum({< Key={"=rank(Sum(Value)) < $(vTop)"}>}Value)

sadabala_bi
New Contributor II

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

Yes

sadabala_bi
New Contributor II

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

Hi Ramon,

Where can i write this expression, can u please give more clarification on this.

Kind Regards......

ramoncova06
Valued Contributor III

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

write this as part of the expression

https://community.qlik.com/docs/DOC-4951

this link will give you some example of set analysis

sadabala_bi
New Contributor II

Re: How to make our chart dynamically change based on the customized field Top(5,10,15)

HI,

Here is the solution for this.

1).Download the variable extension from https://github.com/erikwett/qsVariable/raw/master/dist/variable.zip and extract       to extensions folder of Qlik Sense. The variable extension is visible in the charts tab as shown in below image. and         choose Render as field from and give name as vTop save it and use vTop in your above expression for the specific         measure to be used in the chart or table...

q.png

2).Drag and drop the extension to the work pane.

3).Before that create a variable(here vTop is my variable).

q1.png

4) Give this name reference to the variable extension Field.

q2.png

5)Now write the expression of measure using the variable "vTop" like

Sum({<Dealer = {"=rank(sum(support_count))<= $(vTop)"}>}support_count)

6)now we can see the Top values based on the entered value.

q3.png

Thanks,

Sattipandu.