Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation

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.

11 Replies
qliksus
Specialist II
Specialist II

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

Not applicable
Author

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
Not applicable
Author

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


Not applicable
Author

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

Not applicable
Author

Hi Melik,

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

Regards,

Vijay

Not applicable
Author

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

Not applicable
Author

Please Open attached QVW file.

Regards,

Vijay

Not applicable
Author

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"

Not applicable
Author

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.