Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be try this
FirstSortedValue(Produto, -Aggr(Sum({$<YEAR={$(=Max(YEAR))}>} ValorVenda), Produto))
Or this
Concat(Aggr(If(Rank(Sum({$<YEAR={$(=Max(YEAR))}>} ValorVenda)) < 2, Produto), Produto), ', ')
As usuall, perfect solution. Now how can i put dat in bold?
Thank you for the help
Put what in bold?
the product.
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.