Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Why is Set variable dollar expansion not working?

Hi,

I have a script like this in my app:

NULLASVALUE Country, Product, CustomerName;

SET NullValue = 'Not Found';

LOAD

<Fields>,

Country,

If(Country=$(NullValue), Null(), Country) as CustomerCountry

Resident <Table>

My NullValue dollar expansion is not working.

Any idea what I am doing wrong please?

I cannot remove the field from NULLASVALUE because it is required.

1 Reply
Highlighted
Champion
Champion

Hi,,

I think you should write it like this:

If(Country='$(NullValue)', Null(), Country) as CustomerCountry