topic Re: Top 5 Sales in Bar chart in QlikView

Top 5 Sales in Bar chart

srinivasa1 — Wed, 21 Sep 2016 04:15:07 GMT

Can please guide me how i can show top 5 Product bases on 'Maintenance' Sales

eg.

1,985

2,1055,

2,1130

4,1205

5,1272

Attached sample qvw on same.

Thanks

Re: Top 5 Sales in Bar chart

amit_saini — Wed, 21 Sep 2016 04:23:46 GMT

Hi,

Try

Syntax:

=rank(sum(Investment),1,1)

=aggr(if(Rank(sum(Investment))<=3,Investment),Investment) (For calculating Top 3)

=if(rank(sum(Investment),1,1)=1,'# 1')

I have a data table which includes the following fields; SystemID, Timestamp.

I want to derive a new field in this table which ranks the Timestamp in ascending grouped by SystemID

I'd like to do this in the script.

e.g.

SystemID, Timestamp, [Rank]

00001, 01/01/2013 10:00, 1

00001, 01/01/2013 12:00, 2

00001, 01/01/2013 12:30, 3

00002, 01/01/2013 11:00, 1

00002, 01/01/2013 12:12, 2

00003, 01/02/2013 10:30, 1

Syntax:

LOAD

SystemID, Timestamp,

if(SystemID=previous(SystemID),peek('Rank')+1,1) as Rank

FROM ...mysource...

ORDER BY SystemID, Timestamp;

Thanks,

Re: Top 5 Sales in Bar chart

Anil_Babu_Samineni — Wed, 21 Sep 2016 06:04:16 GMT

Like this

If you want to show single value like wither H OR I Then use FirstSortedOrder

Re: Top 5 Sales in Bar chart

srinivasa1 — Wed, 21 Sep 2016 19:26:01 GMT

Thanks Amit,

I need do top 5 product in in 2nd expression .

in 'Maintenance' Expression

sum({<Type={'Maintenance'}>}Sales) in this expression value I need to consider for top 5 product

Thanks

Re: Top 5 Sales in Bar chart

srinivasa1 — Wed, 21 Sep 2016 23:41:44 GMT

Thanks All and I have achieved as expected by writing below expression.

=if(Aggr(rank(sum({<[Type]={'FIiled1',
'FIiled2', FIiled3' }> Sales)/count(DISTINCT ID)),[ Product
Line]) <=10,
sum({<[Type]={ 'FIiled2',
FIiled3' }>} Sales count(DISTINCT ID))

Thanks Again!.