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: 
RKULKARNI4
Contributor III
Contributor III

Formula need to deploy

Hello Team,

I am new to Qlik sense, I am trying to add the below mentione formula in Qlik Sense :

if(NAME_1_QUAL<>'V',NAME_2,if(NAME_2_QUAL<>'V',NAME_1,NAME_1+''+NAME_2)),How it can be written in Qlik sense.Please advise.

 

Regards

RK

 

 

 

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

if I understood correctly just change + by &

=if(NAME_1_QUAL<>'V',NAME_2,if(NAME_2_QUAL<>'V',NAME_1,NAME_1&''&NAME_2))

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

if I understood correctly just change + by &

=if(NAME_1_QUAL<>'V',NAME_2,if(NAME_2_QUAL<>'V',NAME_1,NAME_1&''&NAME_2))

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
RKULKARNI4
Contributor III
Contributor III
Author

Thanks