Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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 🙂