Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
brunopaulo
Contributor II

List top Product in text box

Hi community, im trying listing the top product using the following expression.

='O produto mais vendido de ' & max(YEAR) & ' é o ' & concat(aggr(if(rank('Sum({$<YEAR={$(=Max(YEAR))}>}  (ValorVenda))'<2, Produto), Produto),',')

I ccant find the error. can anyone help me? Thank you!

Best Regards

6 Replies

Re: List top Product in text box

May be try this

FirstSortedValue(Produto, -Aggr(Sum({$<YEAR={$(=Max(YEAR))}>} ValorVenda), Produto))

Re: List top Product in text box

Or this

Concat(Aggr(If(Rank(Sum({$<YEAR={$(=Max(YEAR))}>} ValorVenda)) < 2, Produto), Produto), ', ')

brunopaulo
Contributor II

Re: List top Product in text box

As usuall, perfect solution. Now how can i put dat in bold?

Thank you for the help

Re: List top Product in text box

Put what in bold?

brunopaulo
Contributor II

Re: List top Product in text box

the product.

Re: List top Product in text box

From what I understand, either you can format the whole KPI object or nothing.... if you are okay to highlight the whole thing, you should be able to format the text by adding bold... I am not a Qlik Sense expert, but if you don't know where it is, I can check that for you.

Community Browser