Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

paulwalker
Contributor

top 10 sales in textbox

Hi Community,

I have a straight table showing top 10 records, using Dimension Limits.

Expression:

Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice)

My requirement, User want to show in top records in textbox.

I have tried but i didn't get exact value, which I have in Straight table.

Thanks in Advance!

1 Solution

Accepted Solutions
Partner
Partner

Re: top 10 sales in textbox

Try these

='Top 10 - ' & concat( aggr(if(rank(Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice)) <= 10, ProductName), ProductName),chr(10), aggr(rank( Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice) ), ProductName ))

 

Regards

Mustaq

1 Reply
Partner
Partner

Re: top 10 sales in textbox

Try these

='Top 10 - ' & concat( aggr(if(rank(Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice)) <= 10, ProductName), ProductName),chr(10), aggr(rank( Sum({<Customer={'Boleros', 'Bond Ltd', 'Boombastic'}>}LineSalesAmount)
+
Sum(UnitPrice) ), ProductName ))

 

Regards

Mustaq