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.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

Generic Load Help

Hi Qlikers ,

I am trying to pivot Column using Generic Load. I am generating columns from "App Name" Field  and trying to fill values as yes or no , in case user doesn't have access to app. it seems to work however I'm having issue replacing Null with 'No'.  Tried many options but doesn't seems to work. where ever it is  null() I would like to see 'N'

 

Generic
Load Distinct
ID,
"App Name" ,
if(isnull( if ("App Name"='NULL' OR "App Name"=' ',NULL(),"App Name")),'No','Yes') as AccessFlag

RESIDENT [Win Access]
where Match("APP_NUM",150,400)
;

 

arusanah_0-1618333887192.png

 

 

Any help will be appreciated.

 

Thanks

 

Labels (1)
1 Reply
Dalton_Ruer
Support
Support

TER:
Load Territory, Country,
IF(Len(Country) = 0 or IsNull(Country), 'Null', 'Not Null') as Flag Inline [
Territory, Country
EU, DE
EU, FR
ASIA,
USA, US
AF, ''
];