topic Re: top 10 customers by their Invoice Amount in QlikView

top 10 customers by their Invoice Amount

Wed, 25 Nov 2020 16:16:04 GMT

Hi all ,

I am new to Qlik View and this forum as well .

I want to create a Bar Chart which shows top 10 customers by their InvoiceAmount .

Only i know is necessary Tables(SQL Server) from which i have to fetch data .

Now what should i write code so that Bar Code should come up with top 10 customer .

Please guide me .

Thanks .

Re: top 10 customers by their Invoice Amount

Anonymous — Fri, 18 Mar 2016 08:51:18 GMT

Did you check this?

http://www.learnqlickview.com/a-qlikview-tip-how-to-display-top-n-and-bottom-n-values/

Top 5 analysis using Rank fuction

Re: top 10 customers by their Invoice Amount

ali_hijazi — Fri, 18 Mar 2016 08:53:47 GMT

use the out of the box DimensionLimit tab

you can put top 10 and the 10 can be a variable

if your dimension is customer then select customer and choose the options as above

Re: top 10 customers by their Invoice Amount

Chanty4u — Fri, 18 Mar 2016 08:55:19 GMT

try this

Sum({<[Customer Name] = {"=Rank(SUM(TEUS))<=10"}>}TEUS)

Hi,

Try (Calulated Dimension)

Aggr(If(Rank(Expression) <= 10,Customer),Customer)

Re: top 10 customers by their Invoice Amount

avinashelite — Fri, 18 Mar 2016 08:55:55 GMT

one easy way would be ..

1.Add the customers as the dimension

2.Add the expression as sum([invoice amount])

3.Go to dimension limits option the chart properties and select largest 10

4.click on finish

Now you the chart with the top 10 customers based on the invoice

Re: top 10 customers by their Invoice Amount

Kushal_Chawda — Fri, 18 Mar 2016 08:56:19 GMT

Create the bar chart

Dimension : Customer

Expression : Sum(Invoice Amount)

Go to Dimension limit tab-> check restrict data->In show drop down select largest and put 5 in value

Re: top 10 customers by their Invoice Amount

Chanty4u — Fri, 18 Mar 2016 09:00:01 GMT

if it is stright table u will find dimension limit tab there u can restrict.

in pivot table u can use caluclated dimension as mentioned above

Re: top 10 customers by their Invoice Amount

Fri, 18 Mar 2016 09:17:46 GMT

I think Dimension limit tab is not available for version lower than 11 (I am not sure if you are using QV10). So, calculated dimension is always handy. You can try something like this in your dimension tab -> Add Calculated Dimension:

if(aggr(rank(sum(InvoiceAmount)), CustomerID) <= 10, CustomerID).

Also, please suppress NULL values for this calculated dimension.

Thanks!

Re: top 10 customers by their Invoice Amount

engishfaque — Fri, 18 Mar 2016 10:05:47 GMT

Dear Gautam,

Kindly find attached App, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

Re: top 10 customers by their Invoice Amount

Fri, 18 Mar 2016 11:14:09 GMT

Hi Ahmed ,

Thanks for the App , it worked .