topic Re: Text Box Expression in QlikView

Text Box Expression

Wed, 30 Jul 2014 02:48:05 GMT

Hello,

I've a text box, with current expression as "=max(aggr(count(Total_Number),[group_tour]))"

And the output was " 102820 " , which is correct.

However, I would like it to be percentage instead.

According to my chart, 102820 is actually = 18.06% , which is also the largest portion in the chart, group_tour.

But how do I change the the output from 102820 to 18.06% , so that it corresponds with the chart?

Thank you!

Anonymous — Wed, 30 Jul 2014 03:44:25 GMT

Hi Daphnegxy,

Could you please share an example.

Regads,

eduardo_sommer — Wed, 30 Jul 2014 03:47:55 GMT

Hi,

Try

=num(max(aggr(count(Total_Number),[group_tour])) / count (Total Total_Number), '#0,00 %')

Eduardo

Wed, 30 Jul 2014 03:52:00 GMT

Thank you for your reply! However, this solution didnt work 😞

It gave me a percentage, however the percentage wasnt 18.06%, like what i would see in the chart "group_tour" 😞

eduardo_sommer — Wed, 30 Jul 2014 03:56:55 GMT

Is it possible to share your app?

Try also a modification to my earlier expression:

=num(max(aggr(count(Total_Number),[group_tour])) / count (Total_Number), '#0,00 %')

I took the Total from the second count. Maybe you have some selections, then the Total would ignore them.

Eduardo

Wed, 30 Jul 2014 06:19:10 GMT

It worked!! Thank you so much!!