Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
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...
2).Drag and drop the extension to the work pane.
3).Before that create a variable(here vTop is my variable).
4) Give this name reference to the variable extension Field.
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.
Thanks,
Sattipandu.
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 ?
you need to use a key field but this should work
sum({< Key={"=rank(Sum(Value)) < $(vTop)"}>}Value)
Yes
Hi Ramon,
Where can i write this expression, can u please give more clarification on this.
Kind Regards......
write this as part of the expression
https://community.qlik.com/docs/DOC-4951
this link will give you some example of set analysis
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...
2).Drag and drop the extension to the work pane.
3).Before that create a variable(here vTop is my variable).
4) Give this name reference to the variable extension Field.
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.
Thanks,
Sattipandu.