Solved: Re: how to show top 10 values in 10 text boxes.... - Qlik Community

Report Inappropriate Content · ‎2015-09-18

Area, count(area)

a,3

b,9

c,2

d,5

e,1

f,12

g,4

display like..

textbox1- f:12,

textbox2- b:9,

.

textbox10- j:40

pokassov · ‎2015-09-18

Hi!

=only(if(Aggr(Rank(sum(area))=1,Area),Area))&' '&sum({$<Area={'=Rank(sum(area))=1'}>} area)

=only(if(Aggr(Rank(sum(area))=2,Area),Area))&' '&sum({$<Area={'=Rank(sum(area))=2'}>} area)

...

Report Inappropriate Content · ‎2015-09-18

Hi,

Go through the attached qvw file

Report Inappropriate Content · ‎2015-09-18

please give me the correct answer if any one knows......unfortunately I am clicking that assumed answered answer that question.

Advanced thank you....

Report Inappropriate Content · ‎2015-09-18

Hi,

Go through the above attached qvw, it will answer your question.

Thanks

Harshitha

Report Inappropriate Content · ‎2015-09-18

tanq for reply

but I cant opened u qvw ....canu pls attach any text file r expreesion...

gautik92 · ‎2015-09-18

only(aggr(if(Rank(count(area))=1, Area), Area))

Report Inappropriate Content · ‎2015-09-18

Hi,

= IF ( Aggr ( Rank ( Sum ( count(area))) , Area ) <= 5 , Sum ( count(area)) )

Report Inappropriate Content · ‎2015-09-18

thank you gowtham,

this expression shows only dimension not showing value...

I want show both dimension and value..

Report Inappropriate Content · ‎2015-09-18

Hi,

='Area=' & only(aggr(if(Rank(count(area))=1, Area), Area))

Report Inappropriate Content · ‎2015-09-18

Hi,

Did u get the right working of ur qvw.