Calculation

[#1]

Hello,

I am beginner at Qlikview. I am good at vba and other coding languages but i dont know how it works in qlikview. in qlikview i have sku list and amount of revenue which is gained from that sku. i want to calculate the # of top SKU's which is equal to %80 of sales

thank you.

[qliksus]

Hi,

Use DimensionLimit function in Chart to get 80% etc. No need to use vba.

Create Chart -> Properties-> DimensionLimit-> Show only values that acculumates to

[#3]

hi,

thank you for answer. actually i have already done that. but what i need is number of sku's. what you mentioned will give me a list of top sku's which forms %80 of revenue but not the number.

[Anonymous]

Here is an easy way to get the number, certainly not a comprehensive one:

Create a text box with text:
=count(distinct SKU)

Create action in the same text box

Action: Pareto Select; Field: SKU; Expression: sum(Sales); Percentage: 80

Now, if you clear selections (or make selections you want), and click the text box, it will show you the number.

In general, the solution for your problem depends on how you want to present it.  Maybe you can build on my suggestion, or maybe you need something completely different...

Regards,

Michael

[#5]

That is exactly what i want but when i apply these things it gives me just number of different skus. i dont know what i did wrong

[#6]

Hi Melik,

If my understanding is proper, I tried something which may help you.

Regards,

Vijay

[#7]

can i see what you have done please? thank you so much

[#8]

Please Open attached QVW file.

Regards,

Vijay

[#9]

Thank you so much it is really helpful but i already have that. What i want is just how many skus provide that percentage. ex. i chose %70 percent and listbox brought me a,b and c what i want is a way to bring me number of "3"

[#10]

Just note by using of this feature (dimension limits), others users often has a result on chart like "No data to display" because some selections or data sets don't reach expected percentage.

I hope it helps, regards.