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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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