topic Calculation in QlikView

Calculation

Wed, 27 Nov 2013 12:40:46 GMT

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.

Re: Calculation

qliksus — Wed, 27 Nov 2013 14:38:13 GMT

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

Re: Calculation

Wed, 27 Nov 2013 15:31:53 GMT

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.

Re: Calculation

Anonymous — Wed, 27 Nov 2013 16:51:31 GMT

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

Re: Calculation

Thu, 28 Nov 2013 06:26:51 GMT

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

Re: Re: Calculation

Thu, 28 Nov 2013 10:12:07 GMT

Hi Melik,

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

Regards,

Vijay

Re: Re: Calculation

Thu, 28 Nov 2013 11:38:10 GMT

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

Re: Calculation

Thu, 28 Nov 2013 12:31:32 GMT

Please Open attached QVW file.

Regards,

Vijay

Re: Calculation

Thu, 28 Nov 2013 13:18:47 GMT

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"

Re: Calculation

Thu, 28 Nov 2013 13:33:07 GMT

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.

Re: Calculation

Thu, 28 Nov 2013 13:43:20 GMT

I think you could just use the GetAlternativeCount(Fieldname) function.

You could for example display it in a textbox.

If the GetAlternativeCount() function doenst work try one of the other Get.....() Functions, you can find them in the qlikview Reference Manual --> System Functions.

Re: Calculation

Mon, 02 Dec 2013 09:40:27 GMT

Sir,

I got it until Row section. It writes "1" the rows will be selected but i dont know how you trigger the selection. I did it, and at the next column of rows will be selected, "1" is written but i dont know how can i make them selected. I hope i could express myself. Thank you by the way. If i can do that and then say countselected() then i will be done.