topic Re: Pivot table: incremental count expression of the first N elements in QlikView

Pivot table: incremental count expression of the first N elements

Thu, 07 Feb 2013 16:31:26 GMT

Hi everybody,

I'm working with pivot table, I've got a column with the factory (the most productive ones),in the second the count of produtcs built in the factory, in the third the incremental counter (but only for the first 35 or 10 elements), in the 4th the percentage of the incremental counter (on the total) .

factory	number product	incremental count	% on the total
1	1457	1457	0,42%
2	1376	2833	0,81%
3	1035	3868	1,11%
6	607	4475	1,28%
7	584	5059	1,45%
8	545	5604	1,60%
9	524	6128	1,75%
10	521	6649	1,90%
		36073	10,31%

Can I do anything like that? I'm taking about the incremental count and the percentage.

I know in the straight table you can take choose the first 10 or 30 elements (sorted as you want) but I'd like to do it in a pivot table.

I want not to use too much code (statics table) in the script, because I'd like to let the user change the selections and modify the set of items anytime.

Can you help me?

Kind regards

Re: Pivot table: incremental count expression of the first N elements

Gysbert_Wassenaar — Thu, 07 Feb 2013 20:29:32 GMT

See attached file. It's using just some sample data. Yours would have more records and would probably use (range)count instead of (range)sum. The principles are the same though.

Re: Pivot table: incremental count expression of the first N elements

Mon, 11 Feb 2013 16:33:19 GMT

Thank you Gysbert,

the only difference is that I'd like to take the first 10 elements of a list of 1000.

Your qvw shows all the rows of the table and the total should count only the items of the (10) factory with the best productions.

That's the real question.

Do you think you can handle that?

Amos

Re: Pivot table: incremental count expression of the first N elements

Mon, 11 Feb 2013 16:47:53 GMT

I found the answer here:

http://community.qlik.com/message/48854#48854

Thank you, for your help.

Re: Pivot table: incremental count expression of the first N elements

Gysbert_Wassenaar — Mon, 11 Feb 2013 16:54:22 GMT

Guess you must be using QV10 or earlier. I used Dimension Limits in the original. Here's an updated version that includes a chart using a calculated dimension.

Re: Pivot table: incremental count expression of the first N elements

Mon, 11 Feb 2013 17:10:48 GMT

That's right, I forgot saying I'm using QV10! Sorry for that.

I never hear'd about dimension limits, I wish I could work with 11.

you've been quick and useful, thank you so much.

Re: Pivot table: incremental count expression of the first N elements

Wed, 20 Feb 2013 16:47:22 GMT

I'd like to add a question:

What is the difference between pivot table and straight?

I mean: if I use straight table I canshow the total with sums of rows, but the expression doesn't work properly; otherwise if I choose pivot the total of the columns is 0.

I should attend to a real qvw course, but they are very expensive.

Re: Pivot table: incremental count expression of the first N elements

Thu, 21 Feb 2013 16:00:23 GMT

Another problem comes out if you want to block another dimension in the set analysis.

I mean: If I 'd like to use in the aggr dimension something like:SUM($<YEAR={2012}>} you will have a lot of problem because the dimension won't work properly (the rank can't evaluate the set analysis)

Help!