Data not reflecting in charts

[Anonymous]

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

[jafari_ervin]

please attach your qvw files.

[shiveshsingh]

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?

[Anonymous]

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

[Anonymous]

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

[qliksus]

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

[Anonymous]

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;

[Anonymous]

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

[qliksus]

Try if this helps

Uploading a Sample