topic Re: neglect code from database in QlikView

neglect code from database

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Al,

This is my table in database and I am getting blank data in my chart as for certain items(circled in black) I dont have goadssender (its a primary key ie itemcode in a table ) so I want to neglet those items what query should i use in table to neglect those records ?

Increment_Sales:

LOAD GoodsSender,

InvoiceNumber,

CreateDate,

ItemNumber,

InvoiceQuantity,

SalesPrice,

LocalAmount,

VatAmount,

Walkins;

SQL SELECT *

FROM ETPEASV55.dbo."VW_CashOrderTRN1"

//WHERE InvoiceType = '31' and (CreateDate >= 20150101 and CreateDate <= '$(currentdate)') ;

WHERE InvoiceType = '31' and CreateDate >='20150101' and CreateDate <= convert(nvarchar(8),getdate()-1,112);

store Increment_Sales into C:\Users\dmsadmin\Desktop\QlikView_UCB_Report\QVD\extract_qvd\Increment_Sales.qvd;

drop table Increment_Sales;

Re: neglect code from database

shiveshsingh — Thu, 26 Apr 2018 06:29:43 GMT

You can ignore those ids in where clause

Re: neglect code from database

Anonymous — Thu, 26 Apr 2018 06:49:21 GMT

how?

Re: neglect code from database

shiveshsingh — Thu, 26 Apr 2018 07:05:55 GMT

where ID <> 'IDs to be removed'

Re: neglect code from database

sasiparupudi1 — Thu, 26 Apr 2018 13:46:22 GMT

My be try

SQL SELECT *

FROM ETPEASV55.dbo."VW_CashOrderTRN1"

//WHERE InvoiceType = '31' and (CreateDate >= 20150101 and CreateDate <= '$(currentdate)') ;

WHERE InvoiceType = '31' and CreateDate >='20150101' and CreateDate <= convert(nvarchar(8),getdate()-1,112)

and GoodsSender is not null;