Error while using the date

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

Dear Friends,

i am using this set analysis:-

Sum({$<Date_Date = {">=$(=Yearstart(Max(Date_Date))) <= $(=Date(Max(Date_Date)))"},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

And Dimension :- Month(Date_Date)

when i am selected only year (Date_Date) then showing correct date as:-

Date_Date	Month(Date_Date)	Sum({$<Date_Date = {">=01/01/2015 <= 31/01/2015"},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
31/01/2015	Jan	1914457.93
30/01/2015	Jan	583803.52
29/01/2015	Jan	1763469.28
28/01/2015	Jan	1647084.46
27/01/2015	Jan	1850549.60
26/01/2015	Jan	1754736.65
25/01/2015	Jan	1846548.75
24/01/2015	Jan	1670615.16
23/01/2015	Jan	584490.22
22/01/2015	Jan	1907340.51
21/01/2015	Jan	1774922.10
20/01/2015	Jan	1936458.66
19/01/2015	Jan	1963843.90
18/01/2015	Jan	1876147.61
17/01/2015	Jan	1876634.20
16/01/2015	Jan	554669.93
15/01/2015	Jan	1827682.67
14/01/2015	Jan	1761802.97
13/01/2015	Jan	1902599.53
12/01/2015	Jan	1882669.56
11/01/2015	Jan	1847957.63
10/01/2015	Jan	1801115.66
09/01/2015	Jan	543513.62
08/01/2015	Jan	1824360.97
07/01/2015	Jan	1869307.85
06/01/2015	Jan	1926686.54
05/01/2015	Jan	1835259.85
04/01/2015	Jan	1961008.77
03/01/2015	Jan	1682604.74
02/01/2015	Jan	673796.83
01/01/2015	Jan	1521238.44

this is the output

but when i am selecting any date like 31/1/2015

then it showing date including January 2016 also

like this :-

Date_Date	Month(Date_Date)	Sum({$<Date_Date = {">=01/01/2015 <= 31/01/2015"},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
31/01/2016	Jan	27750.00
28/01/2016	Jan	1000.00
26/01/2016	Jan	13520.00
25/01/2016	Jan	8355.00
24/01/2016	Jan	500.00
20/01/2016	Jan	36815.00
19/01/2016	Jan	1457.50
18/01/2016	Jan	6655.00
17/01/2016	Jan	1615.00
13/01/2016	Jan	170.00
12/01/2016	Jan	2330.00
11/01/2016	Jan	1204.50
07/01/2016	Jan	1111.50
01/01/2016	Jan	335.00
31/01/2015	Jan	1914457.93
30/01/2015	Jan	583803.52
29/01/2015	Jan	1763469.28
28/01/2015	Jan	1647084.46
27/01/2015	Jan	1850549.60
26/01/2015	Jan	1754736.65
25/01/2015	Jan	1846548.75
24/01/2015	Jan	1670615.16
23/01/2015	Jan	584490.22
22/01/2015	Jan	1907340.51
21/01/2015	Jan	1774922.10
20/01/2015	Jan	1936458.66
19/01/2015	Jan	1963843.90
18/01/2015	Jan	1876147.61
17/01/2015	Jan	1876634.20
16/01/2015	Jan	554669.93
15/01/2015	Jan	1827682.67
14/01/2015	Jan	1761802.97
13/01/2015	Jan	1902599.53
12/01/2015	Jan	1882669.56
11/01/2015	Jan	1847957.63
10/01/2015	Jan	1801115.66
09/01/2015	Jan	543513.62
08/01/2015	Jan	1824360.97
07/01/2015	Jan	1869307.85
06/01/2015	Jan	1926686.54
05/01/2015	Jan	1835259.85
04/01/2015	Jan	1961008.77
03/01/2015	Jan	1682604.74
02/01/2015	Jan	673796.83
01/01/2015	Jan	1521238.44

why ???

I am using only one set analysis .

Re: Error while using the date

Anil_Babu_Samineni — Mon, 24 Oct 2016 04:37:14 GMT

Mohit, What was the problem, Try with Single Quotes and then see.

Sum({$<Date_Date = {'>=' & '$(=Yearstart(Max(Date_Date)))' '<=' & '$(=Date(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

Re: Error while using the date

tresB — Mon, 24 Oct 2016 05:01:14 GMT

Could you post a sample qvw that demonstrates the issue?

Re: Error while using the date

mohitd910 — Mon, 24 Oct 2016 06:03:30 GMT

Solved Bro it is the correct measure SUM({$<Date_Date= {'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

Refer this Error in Set analysis or Date error

topic Re: Error while using the date in QlikView

Error while using the date

Re: Error while using the date

Re: Error while using the date

Re: Error while using the date