Error in Set analysis or Date error

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 in Set analysis or Date error

sunny_talwar — Sun, 23 Oct 2016 19:18:42 GMT

This is a weird behavior, but I think we would need to see more information before we can say what might not be working. Can you provide more information?

Re: Error in Set analysis or Date error

mohitd910 — Sun, 23 Oct 2016 19:20:30 GMT

Like which type of information

Re: Error in Set analysis or Date error

mohitd910 — Sun, 23 Oct 2016 19:28:37 GMT

this is the correct output and data is corresponding to months

Re: Error in Set analysis or Date error

mohitd910 — Sun, 23 Oct 2016 19:29:51 GMT

this is according to date is is showing wrong data.

Re: Error in Set analysis or Date error

mohitd910 — Sun, 23 Oct 2016 19:39:08 GMT

why is it creating the problem bro . stalwar1‌ mrkachhiaimp‌ nagarjuna.kothamandi‌ mayilvahanan‌ jagan‌

Re: Error in Set analysis or Date error

mohitd910 — Sun, 23 Oct 2016 20:30:31 GMT

solved

Set analysis

SUM({$<Date_Date = {'>=$(=YearStart(Max(Date_Date)))<=$(=YearEnd(Max(Date_Date)))'},Flag={'Visit TYPE REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)

topic Re: Error in Set analysis or Date error in QlikView

Error in Set analysis or Date error

Re: Error in Set analysis or Date error

Re: Error in Set analysis or Date error

Re: Error in Set analysis or Date error

Re: Error in Set analysis or Date error

Re: Error in Set analysis or Date error

Re: Error in Set analysis or Date error