topic Re: Help needed with evaluating Count expression in QlikView

Help needed with evaluating Count expression

Sat, 20 Apr 2013 09:26:10 GMT

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.

Re: Help needed with evaluating Count expression

swuehl — Sat, 20 Apr 2013 10:06:21 GMT

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);

Re: Help needed with evaluating Count expression

Sun, 21 Apr 2013 09:44:52 GMT

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.

Re: Help needed with evaluating Count expression

swuehl — Sun, 21 Apr 2013 17:08:57 GMT

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.