This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to restrict
where YEAR = 2015 and 2016.
how to do this in qlikview.
If you want to restrict it while loading the data from database then do it like below
SQL SELECT *
where YEARFIELD IN ('2015','2016');
STORE Data into path\Tablename.QVD;
DROP TABLE Data;
if you want to restrict this in Qlikview script
If you want to restrict at chart level use the below expression
View solution in original post
You can add it in script almost like SQL.
where(year = ('2015') or year = ('2016'));
Where do you want to restrict this? In a chart or with loading the data?
Niklas. Might be he want, 2015 and 2016 data..
WHERE YEAR IN (2015, 2016);
This is worked. thanks Kishal.