Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Null / Blanks in Excel Import

Hi,

I have a field I'm pulling in from excel, 'Group No':

     Upper(if([Group No]=0,'GR-000000',

     if([Group No]='','GR-000000',[Group No]))) As [Group No],

The problem is, that if the field is blank in excel, I want to populate it with 'GR-000000'.

I've tried '', as you can see from above, with no luck.

Its producing a line in my pivot table with a - where the GR number should be.


How can I replace any 'blanks' with 'GR-000000'?


Thanks


Di


1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

If(len([Group No]) = 0, 'GR-000000', Upper([Group No]) as [Group No],


or

If(len(Trim([Group No])) = 0, 'GR-000000', Upper([Group No]) as [Group No],

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

If(len([Group No]) = 0, 'GR-000000', Upper([Group No]) as [Group No],


or

If(len(Trim([Group No])) = 0, 'GR-000000', Upper([Group No]) as [Group No],

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
trdandamudi
Master II
Master II

Try below:

If(Len(Trim([Group No])>0), [Group No],'GR-000000'))) As [Group No]