topic Re: expression in QlikView

expression

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Epression :

=Chr(39) &

Concat

(

$(Dashboard_Leads_DistrictRankings_Rank) > $(Dashboard_Leads_DistrictRankings_RowNo),

Chr(11) & District_Hierarchy_Name

Chr(39) & ',' & Chr(39),

$(Dashboard_Leads_DistrictRankings_Rank)

) & Chr(39)

I want to show bottom 5 ranking , but the above expression is giving me bottom 7 rankings.

Can any one suggest me how do i reduce it to bottom 5 rankings .is there any way that i use to show only 5 bottom rankings by adding or making some change to the above expression ?

Thanks in Advance

Re: expression

lironbaram — Tue, 28 Feb 2017 09:51:34 GMT

not sure what exactly you look for in the expression

but usually when i need to find the bottom entities

i use this approach

ranking according to the negative value

for example Concat(aggr(if(rank(-Sum(value))<=5,date),date),',')

this brings back the bottom 5 date according to sum(value)

Re: expression

Anil_Babu_Samineni — Tue, 28 Feb 2017 09:57:54 GMT

Would you elaborate more on variables? How you are indicating for Variables?

As Liron said, You can work on it. I don't think whether you can achieve this or not from your expression. Can you tell me where you are trying this?

Re: expression

smilingjohn — Tue, 28 Feb 2017 09:59:06 GMT

iam trying this on bar chart ,

Re: expression

Anil_Babu_Samineni — Tue, 28 Feb 2017 10:05:04 GMT

Is it possible to share the application?

Or try a luck from Dimension Limits -- Check the Check box and use 5 values from Smallest.

Or at last show me your image of your bar object whether how you are receiving using that Expression to UI?

Re: expression

smilingjohn — Tue, 28 Feb 2017 10:12:40 GMT

Thanks Anil ,

Actaully that expression works perfectly for other brand and gives me top 5 and bottom ranking of the subcategroy within the product category..and i have written only bottom 5 expression on this community , but this bottom 5 ranking is showing 7 subcategory for the new product , with double entries , as shown in the image ... If you see in the image the the bottom 5 is from EAA to EA1 ...

Re: expression

Anil_Babu_Samineni — Tue, 28 Feb 2017 10:21:09 GMT

But, You have subcategory with different names. So that, It won't and try to remove the dimension and use sample Dimension and then see. How it comes

Would you able to provide sample, Please?

Re: expression

smilingjohn — Tue, 28 Feb 2017 10:32:16 GMT

In dimesion iam using value list