Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
swapna_shree
Partner - Contributor
Partner - Contributor

concatenating future weeks in a Pivot Table

c40a267a0c984a5aae76f7d8868c788f.jpg

Hi Team ,

I am stuck in a part of requirement where all 

week _no.

jan 2023 feb 2023 ...... dec 2023
1 552      
2 670      

.

       
12 990      
. 990      
52 990      
         
         
         

 

the value from the current week should be repeated thru all the future weeks . I am stuck at two points .

1. future weeks are not coming so i used master calendar but didnot satisfy my requirement.

2.  The data is not coming as every week we have specific materials and they are not getting mapped .

Please help me out of this .

 

Regards,
Swapna

 

Labels (2)
0 Replies