Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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