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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

QlikView to Qlik Sense Script - Null Rows

Hi there,

I am converting a App from QlikView to QlikSense.

When I run the below script in Qlik Sense , I am facing issue that Data1 Table is loaded with Null rows. However When I run the same script in QlikView, The Data1 Table is loaded with Correct amount of rows. 

trace '$(vCountryFilter)';

if '$(vCountryFilter)'='NewZealand' THEN
LET vCountryFilter='New Zealand';
ENDIF;

if '$(vCountryFilter)'<>'SEA' THEN
right keep (Data1)
TEST:
LOAD '$(vCountryFilter)' as COUNTRY, 1 as FlagTEST INLINE [
COUNTRY
Dummy
];
ENDIF;

 

Purushothaman_0-1650855692122.png

 

Anyone, please help!! 

Thank you!

0 Replies