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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script help

So heres what I'm trying to do.

I have two fields, Group Description and Lean_Projects. They were were in two separate tables but I left joined them together.

So when I make a table I want Lean_Projects to display either 'Lean' or 'Non Lean' depending on the value of Group Description.

Sometimes Lean_projects is null as well, so that would have to change as well.

Any ideas?

1 Reply
MayilVahanan

Hi,

     Try this,

     Load If(IsNull(Lean_Projects),'ZeroLean', Lean_Projects) as Lean ,*

          from FileName.FileExtension

     When you left join the tables, please make sure, both table have common field name.

     Hope it helps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.