topic Re: Data not reflecting in charts in QlikView

Data not reflecting in charts

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

I am stuck at a point. I have report for comparison between sales of 2017 and 2018. I have SaPCode (store code) as a primary key. when I am selecting SAPCode in list box data is not reflected in charts for some SAPCode but for some its working fine.

Please suggest what may be the reason for this ?

Following is the expression used in charts and for this the data is not reflected

=sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_sold))

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_returns))

but if I am using sum(quantity_sold) as expression the data is reflected in charts for same SAPcode

Re: Data not reflecting in charts

jafari_ervin — Mon, 30 Apr 2018 06:02:02 GMT

please attach your qvw files.

Re: Data not reflecting in charts

shiveshsingh — Mon, 30 Apr 2018 07:32:46 GMT

What's the result of this?

sum(if(Sold_Date <= MakeDate(2017,month(To),day(To)) and Sold_Date >= MakeDate(2017,month(From),day(From)) and [Season Code] = $(Master_PreviousSeason), quantity_sold))

Can you attach qvw file?

Re: Data not reflecting in charts

Anonymous — Mon, 30 Apr 2018 09:13:55 GMT

For some SAPCode its coming out to be correct for eg:-store name cp hamilton (selected in list box)

but for some SAPcode its not coming correct.like in above image for eg :- adi/sports jammu wave mall

Re: Data not reflecting in charts

Anonymous — Mon, 30 Apr 2018 09:29:18 GMT

on same chart the data for particular store is coming correct but for some stores data cannot be seen. please help.

Re: Data not reflecting in charts

qliksus — Mon, 30 Apr 2018 09:42:36 GMT

Look like the filter condition is failing for those codes . Take the sold date and season code as a dimension to see whether you have the corresponding dimension value for those codes which are not returning the value

Re: Data not reflecting in charts

Anonymous — Mon, 30 Apr 2018 10:14:32 GMT

here data for season 17P is coming but in database its present

here is the database

//-------- Start Multiple Select Statements ------

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);

//and GoodsSender is not null ;

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

drop table Increment_Sales;

Re: Data not reflecting in charts

Anonymous — Mon, 30 Apr 2018 12:16:03 GMT

i have attached the document but not able to post. how to do it?

Re: Data not reflecting in charts

qliksus — Wed, 02 May 2018 08:25:32 GMT

Try if this helps

Uploading a Sample