Discussion board where members can get started with QlikView.
The question is:
After reload data to my qlickview, with one SQL SELECT, is possible delete rows of this data, with some command? for example
After SQL SELECT
The data with the same number drop
Hi there, I dont quiet undertand the pattern you want to remove, do you want to remove rows with Amount equal to 25?? or rows with Cod equal to 30cod3??
For either case try something similar to the following:
where Cod <> '30cod3';
sql select *
I need delete row with the combination with the same number, code and amount.
Hi there, one thing i forgot is that is not recommended to do any filtering while you are load from the database, because it affects performance, for instance you can save the table in a qvd.