Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harsha
Creator
Creator

Excel Merged cells to copy same data

Hi Experts,

I have data like below (Pic= 1) where Data Element column is merged (ex: Stage, End Rate, Avg Rate) and i want to apply the same values to the below cells like Pic= 2

i tried this formula but it it is being applied only for 2020 and 2021. I don't know why not applying for others.

If(IsNull([Data Element]),Peek([Data Element]),[Data Element]) as [new_Data Element]

pic=1

Qlik1.JPG

pic=2

 Qlik2.JPG

Labels (1)
1 Solution

Accepted Solutions
JordyWegman
Partner - Master
Partner - Master

Hi,

With peek you can search for a column that doesn't exist yet. You have to look for your own field. Try this:
If(IsNull([Data Element]),Peek([new_Data Element]),[Data Element]) as [new_Data Element]

Jordy 

Climber 

Work smarter, not harder

View solution in original post

2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

With peek you can search for a column that doesn't exist yet. You have to look for your own field. Try this:
If(IsNull([Data Element]),Peek([new_Data Element]),[Data Element]) as [new_Data Element]

Jordy 

Climber 

Work smarter, not harder
harsha
Creator
Creator
Author

Thank you for your suggestion Jordy... it worked 🙂