how can we get current sale for a particular year

[Anonymous]

Hi

I am not able to get todays sale in my dashboard

what may be the reason?

[tresesco]

Possible reasons could be numerous, but to track it down, we would require more information like: how your data look like, what expression you are trying, in which object.... You may want to read my recent reply here: Re: Pivot table in qlikview and understand the importance of detail and context.

[Anonymous]

Hi

i want to use calender object and on which when i select todays date the current slaes should be updated in my chart

following is the coding used in my script

SQL SELECT *
FROM ETPEAS.dbo.CashOrderTrn
WHERE InvoiceType = '31' and (CreateDate >= 20130101 and CreateDate <= '$(currentdate)') ;

but only able to see sales till august not after that

what may the reason behind the same?

[tresesco]

How do you define your variable currentdate ?

Is your CreateDate field in YYYYMMDD format or YYYYDDMM format in db?

Have you checked if the db itself has data till today?

[Anonymous]

currentdate is defined as follows

Let currentdate =DATE(Today(1)-1,'YYYYMMDD');
i

[Anonymous]

db has data till today and its in format YYYYDDMM

[prma7799]

try like this

Let currentdate =DATE(Today(1)-1,'YYYYDDMM');

[tresesco]

Your variable format and field date format have to be same.

[Anonymous]

yes this i have checked but still its not showing current sales

[prma7799]

Please share some sample data...