Help needed with evaluating Count expression

[#1]

Hi All,

Please find the following desired output as a table object in my report. I am stuck with the expression for calculating the count(Here count is the calculated column). What needs to be done at the report level itself if i want to have an extra column "Count" which increments itself when a task visits the same transition again, please find the following Table :

Task ID	Transition In	Task	Transition Out	Count
10557115	Proof	R&D	Build	1
10557115	Proof	R&D	Build	2
10557115	Proof	R&D	Build	3
10557115	Proof	R&D	Build	4
10557115	Proof	R&D	Build	5
10557115	Hold	R&D	Build	1
10557115	Hold	R&D	Build	2
10557115	Hold	R&D	Build	3
10557115	Hold	R&D	Build	4
10557115	Hold	R&D	Build	5
10653829	Review	R&D	Build	1
11562281	Review	R&D	Build	1
11562281	Review	R&D	EB	2
11562281	Review	R&D	EB	3
12594118	Review	R&D	EB	1
15423802	Proof	R&D	Build	1
15423802	Proof	R&D	Build	2
15423802	Proof	R&D	EB	3
15423802	Review	R&D	EB	1
15423802	Review	R&D	EB	2
15423802	Review	R&D	EB	3
15423802	Review	R&D	Build	4

should this be achieved at script level/report level, if so can you guys help me with the expression.

I think we should write and iteration statement if we have to handle this at script level. Any help in this regard is highly appreciated.

Thanks & Regards,

Abhinay.

[swuehl]

If I understood your request correctly, I would do this in the script:

LOAD RecNo() as RecID,

     [Task ID],

     [Transition In],

     Task,

     [Transition Out],

    AutoNumber(RecNo(), [Task ID] & [Transition In]) as Count

FROM

[http://community.qlik.com/thread/80218?tstart=0]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

Hi Swuehl,

Thanks for the reply. Could you help me with the expression if i would like to accomplish the same at the report level using Table object.

Thanks,

Abhinay.

[swuehl]

Try an expression like

=if(isnull(above( RecID)),1,rangesum(above("ExpCount"),1))

[where I used ExpCount as expression label]

Have a close look at the dimensions I used (TaskID, Transition In, RecID), and that I hided RecID dimension, but sorted after that field.