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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quick help in if formula

Unfortunately today I've got problem with connection to my databases. I'm trying from few days build customer segmentaion. Probably "I'm in home" but I need to know if below code is correct. I can't check this with QV file. I'm interesting of cheking if formula with and


Segment:
load
[Client number],
[BU],
[Factory],
[Sales person (Client)],
if([Factory]='NAM', 'FIRE',if(([Sales person (Client)]='170013' and
[Factory]='PRU'), 'PROJEKTY',[BU])) as [Business Unit]
resident Sales;




2 Replies
Not applicable
Author

Syntax seems to be correct

Not applicable
Author

Thanks a lot:) This really simplify my work:):)