topic Re: top5 in QlikView

top5

Tue, 06 May 2014 08:50:56 GMT

Hi all,

Is it possible to make a text box that gives me the percentage of:

top 5 customers = (sales vs budget) last week vs this week?

kind regards

Vincent

Re: top5

tresB — Tue, 06 May 2014 08:59:15 GMT

May be possible. Your sample qvw could help us help you.

Re: top5

Anonymous — Tue, 06 May 2014 08:59:22 GMT

Hi Vincent,

Yes that is perfecly possible.

How to do this depends on your data.

Could you maybe share a Qlikview document with some (dummy) data?

Dennis.

Re: top5

Tue, 06 May 2014 09:00:26 GMT

Hi Vincent,

yes, it is possible.

But how to do it deppends on your data model.

And .... it will be easier to have this in chart like straight table.

regards

Darek

Re: top5

Tue, 06 May 2014 09:07:50 GMT

It's possible to make a sample app with scrambeling my data right?

But I was thinking

num((sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW)'}, Customername = {'1'} + { '2' } .... 5, } >} RevenueAmount)

/(sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW)'}, Customername = {'1'} + { '2' } .... 5, } >} Budgetamount)

/((sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW-1)'}, Customername = {'1'} + { '2' } .... 5, } >} RevenueAmount)

/(sum({1< Year = {$(=vStaticCY)}, Week = {'$(=vStaticW-1)'}, Customername = {'1'} + { '2' } .... 5, } >} Budgetamount),'###%')

I know some ()() are missing but this was my first idea to solve this problem

Re: top5

Anonymous — Tue, 06 May 2014 11:37:28 GMT

Hi Vincent,

please find the below expression for displaying the top 5 branch_code,according to sales value.

first expression will be display the top 5 branches and second expression for sales values for top 5 branches.

expression 1:

=chr(39)&Concat(if(aggr(rank(sum({<BRANCH_CODE=>} Sales_value)),BRANCH_CODE)<=5,BRANCH_CODE),chr(39)&','&chr(39))&chr(39)

expression 2:

=sum({<BRANCH_CODE={$(=chr(39)&Concat(if(aggr(rank(sum({<BRANCH_CODE=>} Sales_value)),BRANCH_CODE)<=5,BRANCH_CODE),chr(39)&','&chr(39))&chr(39))}>} Sales_value)

Thanks

SHAIK

Re: top5

Tue, 06 May 2014 11:47:54 GMT

what do you mean with chr 39?

Re: top5

Anonymous — Tue, 06 May 2014 12:05:30 GMT

Hi Vincent,

chr(39) will be return the ( ' ) single quotes.39 is ASCII value of single quotes.