Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to qliksense. I am trying to load a file which have many fields in it. There is field name by Country in which i have name of the countries and "Total" in it. While loading the data i do not want Total to get loaded in the script.
Pls help.
Regards,
Avinash
May be like this
Where Country <> 'Total';
Load *
from yourSource where Country<>'Total';
try
Load Country,
.
.
.
.
From filename
where 1-sign(Match(Country,'Total'));
Hi
Load * from source where Country <> 'Total'
Thanks. It worked.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .