Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In Qliksense pivot table I am showing values week on week basis.
My requirement is once all weeks completed for particular month the. MTD column should show and then again week to be continued forthe next coming months.
For eg : Apr has total 4 weeks then first 4 columns should be Week 1 to Week 4 and 5th column will be Apr MTD.
6th column onwards Week 6- Week 10 and 11th column will be May MTD.
you could have month, then the week as the columns in the pivot. that ought to give you a monthly summary for the weeks covered in the given month.