Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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.
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.