Discussion board where members can get started with Qlik Sense.
Hi all friendly Qlik users
I am pretty new to this Qlik universe, and in general the Java, HTML language, so maybe this will be an easy one to help me with.
I am loading 6 CSV. files that I would like to filter in, especially the " orgUnit" where there are 3 different names, but I am only interested in one of them for my app.
I know there is something called a " Where clause" but am unable to find any help about my specific load.
In this load, I would like to filter in the "orgUnit" and only load the name " AALB " into my app from that "orgUnit"
(txt, unicode, embedded labels, delimiter is ';', msq);
Go to Solution.
Please use the where condition after the from clause. as mentioned below
(txt, unicode, embedded labels, delimiter is ';', msq)
Where orgUnit = 'AALB' ;
That was a fast and absolutely correct answer