Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to combine two time period & create a new field for new period

As per the attached data, it has reported Month, Paid Month but I need to create a new field as Tran_Month only when Reported Year & Month equal to Paid Year & Month in the script. After that I need to pick Month provision+ Under over adjustment for that particular created Tran_Month. How this is done.

Thanks In advance

Neville

12 Replies
breno_morais
Partner - Contributor III
Partner - Contributor III

Yeah, everything will work.

nevilledhamsiri
Specialist
Specialist
Author

Dear Breno,

When clicked on  IT IS why only Monthly provision is shown? Under provision is shown

breno_morais
Partner - Contributor III
Partner - Contributor III

When you click in IT IS, just show "Reported Year & Month equal to Paid Year & Month".