topic Re: Create a Dimension Based On Top Customer. in QlikView

Create a Dimension Based On Top Customer.

infosense_devel — Tue, 05 Jul 2016 08:52:19 GMT

Hello,

I have customer name as dimension and expression to calculate their invoice.

I want show top customer category wise something like this,

In top 10 invoice showing for 1-10 Customer and so On and also want display count of customer.

MK_QSL — Tue, 05 Jul 2016 08:54:30 GMT

Use combination of

Aggr, Rank, If, SUM(Sales) to create Calculated Dimension...

You can also use ValueList Function and use Expressions accordingly..

Better if you provide sample data to work along with the expected results based on sample data.

antoniotiman — Tue, 05 Jul 2016 09:01:27 GMT

Hi,

Try Calculated Dimension

=Aggr(Class(Rank(Sum(Invoice),4),10),Customer)

infosense_devel — Tue, 05 Jul 2016 09:08:38 GMT

And for Expression Side?

antoniotiman — Tue, 05 Jul 2016 09:12:24 GMT

Sum(Invoice)