Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing value in table script

Dear all,

I have tried to assign misisng value in table with Unknown, but the script does not work.

SAP:
LOAD * INLINE
[
Group Name, Value
GA1234, 2897
GA4567, 7000
GA9831 ,1200
GA5671,9400
]
;

  POLFA:
LOAD * INLINE
[
Group Name
GA1234,
GA4567,
GA9831
]
;

  Group:
LOAD * INLINE [
Group
POLFA
]

;

JOIN (Group)
LOAD
[Group Name]
Resident POLFA
;

DROP Table POLFA;

LOAD
[Group Name],
if(Group = '-', 'Unknown', Group) as Group /*This does not work*/
Resident Group;

The problem is  that GA9831 cannot be assigned with 'Unknown'.

Could you please give me an advice how to handle this?

Best regards,

Cornelis

11 Replies
Not applicable
Author

Good to hear from you.

It sounds encouraging that there are people that are willing to help me on way, like you.

Have a great day.

Not applicable
Author

Good to hear from you.

It sounds encouraging that there are people that are willing to help me on way, like you and Kush..

Have a great day.