topic Re: urgent requirement in QlikView

urgent requirement

Anonymous — Wed, 20 Jun 2018 06:57:38 GMT

I have my data assigned a rank against it like this:

rank	values
1	456
2	400
3	300
4	234

this works fine to be displayed in straight table in qlik,

now I want similar functionality in my text objects too,so it shud pick up the rank automatically according to the decreasing order of the values displayed ,expressions used for two columns are as below:

rank(count(distinct id),dimension) (for rank column)

=count(distinct id) (for values column)

rank	values
	456
	400
	300
	234

Re: urgent requirement

Chanty4u — Wed, 20 Jun 2018 07:32:24 GMT

may be this you want?

Ranking position on a text box

Re: urgent requirement

Anonymous — Wed, 20 Jun 2018 07:50:06 GMT

thanks,but its not givng me the desired ranks,

Re: urgent requirement

Anonymous — Wed, 20 Jun 2018 07:57:06 GMT

rank(count({<dimension>}distinct id),dimension)

its just giving balnk,no ranks,

and if I hardcode the values:

rank(count({<dimension={'value1'}>}distinct id),dimension)

rank(count({<dimension={'value2}>}distinct id),dimension)

rank is not changing in this case?

Re: urgent requirement

avinashelite — Wed, 20 Jun 2018 09:27:14 GMT

if your trying it in the text box add the aggr and concat .e.g.

=Concat(Aggr(rank(Count(distinct ID),dimension),dimension),':')

Re: urgent requirement

Anonymous — Thu, 21 Jun 2018 11:11:10 GMT

thanks for sharing this,

the logic seems to be working fine,when am selecting values from a list box,

but when I hardcode the field values in that ,

text object is not giving me desired output,

like for eg:rank(count({<dimension>}distinct id),dimension)

tis is working fine,so if I select any value from the list box giving the right rank,

but if I do like this:rank(count({<dimension={'value1'}>}distinct id),dimension)

this is not taking the right ranks for the dimension values

(selections made on the sheet for other filters)

kndly help,

Re: urgent requirement

Anonymous — Fri, 22 Jun 2018 07:31:46 GMT

can anyone help regarding the same,

Re: urgent requirement

ogautier62 — Fri, 22 Jun 2018 08:52:34 GMT

Hi,

in dimension :

if(getselectedcount("dimension")>0, if( getfieldselections('dimension') <> 'total',$(= getfieldselections("dimension")), ),)

and then expression :

rank(count distinct id)

count(distinct id)

regards

Re: urgent requirement

Anonymous — Fri, 22 Jun 2018 09:30:58 GMT

am using a text object for this

Re: urgent requirement

ogautier62 — Fri, 22 Jun 2018 10:48:17 GMT

ok,

but why use a text object to display multiple rows ??

Re: urgent requirement

ogautier62 — Fri, 22 Jun 2018 11:00:42 GMT

Here is,

= concat(aggr(count( distinct id), $(=if(getselectedcount("dim")>0, if( getfieldselections('dim') <> 'total',getfieldselections("dim"),),))),'\n')

just add rank too

count( distinct id) & ' ' & rank(......

Re: urgent requirement

Anonymous — Fri, 22 Jun 2018 11:24:43 GMT

thanks for sharing this,but It doesn't seem to be working.

and also am not so clear on the logic,can you please help in explaining this.

Re: urgent requirement

Anonymous — Tue, 26 Jun 2018 07:10:21 GMT

looking forward for the response on this.

Re: urgent requirement

raajaswin — Tue, 26 Jun 2018 07:16:05 GMT

u want maximum rank and its value in text box? can you explain the desired output

Re: urgent requirement

Anonymous — Tue, 26 Jun 2018 10:04:37 GMT

rank	values
1	456
2	400
3	300
4	234

Re: urgent requirement

manoj217 — Tue, 26 Jun 2018 10:09:08 GMT

Text object will show only one value not all the values.

if you want all the values means you have to choose list box, else you can show only one value in text object (rank 1 value)

Re: urgent requirement

Anonymous — Tue, 26 Jun 2018 11:17:53 GMT

Hello..

You can do this in backend.

i have created inline table with value in random sequence

test:

LOAD * INLINE [

value

500

300

350

200

250

100

];

then i use preceding load where values are order by descending order and then i applied Autonumber() for ranking in decresing order

load *,

AutoNumber(value) as rank;

load

value

Resident test

order by value desc;

so if u select any value it will display rank with respect to that value

Re: urgent requirement

Anonymous — Wed, 27 Jun 2018 07:28:32 GMT

yes thats great,thanks for sharing this,so this is working when u select values from a list box,suppose,

u need to do the same functionality in a text object ,then how would u do it?

like if u hardcode these values 100,200,250 so on like this u have 6 text objects,

how it will be achieved?