Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

help with custom cummulation in pivot table

Dears

working on defects analysis in a software issue tracker system

I have defects for each release , defects can have as Defect_detection_Phase either  pre_release or post_release

and if the defect is post_release then the column that is called Release_Phase will be equal to Release & '-PR'

in the attached qvw I have a pivot table showing the count of backported defects by fixt period, release and release phase

the first expression is very fine

what I want in the second expression is to show on the release_phase (first one) the count of defects in this release plus those in the post release phase

check the pivot table and it's going to be easy to understand

what I want to achieve is almost done but how can I make for the fix_period 3 to have the value 70 on the first row not the second

result is correct whenever value of the pre-release period is greater than that of the post release

please do not hesitate to ask any question

I can walk on water when it freezes
1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
ali_hijazi
Partner - Master II
Partner - Master II
Author

thank you very much indeed

I can walk on water when it freezes