topic Re: Value & Max(Aggr(Value)) in QlikView

Value & Max(Aggr(Value))

daniel_bernal_y — Thu, 05 Jul 2018 17:35:12 GMT

Hi there,

I want to obtain something like this: "White colour: 85%",

where White colour appears 85% times from total in the table.

I'm using Max(Aggr()) to obtain 85% value into a TEXT OBJECT, but... How can I get the value "White colour" from the table?

Theres only six colours in the table. White colour has more appearances.

Thanks in advance!

Re: Value & Max(Aggr(Value))

neelamsaroha157 — Thu, 05 Jul 2018 17:56:14 GMT

Can you share a sample file.

Re: Value & Max(Aggr(Value))

daniel_bernal_y — Thu, 05 Jul 2018 18:07:31 GMT

Sure I can.

Please replace "White colour" by "Todos los días" (All days), and the biggest % is equal to sum "Satisfecho" and "Muy satisfecho" values from total.

So, the only line that I want get is: "Todos los días: 85%"

Obs.: 85% is not the true value.

Thanks!

Re: Value & Max(Aggr(Value))

neelamsaroha157 — Thu, 05 Jul 2018 18:55:21 GMT

You can achieve the same results using a table. Check out the attachment.

Re: Value & Max(Aggr(Value))

daniel_bernal_y — Thu, 05 Jul 2018 19:04:55 GMT

I know that I can using a table, but is not the format required. The format required is a single line with 2 records separate by ":", like this: "White colour: 85%".

I'm using a Text object, and I can't get "White colour" text, just 85% using Max(Aggr()).

I don't know if I can explain myself or is very difficult to develop.

Note: I can't open you qvw file because licence issue

Thanks again.

Re: Value & Max(Aggr(Value))

zoltann14 — Thu, 05 Jul 2018 21:08:26 GMT

Hi,

You can use the FirstSortedValue() function, for example something like this:

=FirstSortedValue(P2_2,-aggr(Count(P2_2),P2_2)) &' : '&

NUM(Max(aggr(Count(P2_2),P2_2))/Count(Total P2_2),'#0,00%')