script help

[#1]

Hi,

I have two field i.e. - Invoice Date and Amount, I want this

Invoice Date	Amount	Output -->	Invoice Date	Amount
01/01/2015	1		31/01/2015	301
02/01/2015	11		28/02/2015	581
03/01/2015	21		31/03/2015	891
04/01/2015	31		30/04/2015	1191
05/01/2015	41		01/05/2015	1201
06/01/2015	51		02/05/2015	1211
07/01/2015	61		03/05/2015	1221
08/01/2015	71		04/05/2015	1231
09/01/2015	81		05/05/2015	1241
10/01/2015	91		06/05/2015	1251
11/01/2015	101		07/05/2015	1261
12/01/2015	111		08/05/2015	1271
13/01/2015	121		09/05/2015	1281
14/01/2015	131		10/05/2015	1291
15/01/2015	141		11/05/2015	1301
16/01/2015	151		12/05/2015	1311
17/01/2015	161		13/05/2015	1321
18/01/2015	171		14/05/2015	1331
19/01/2015	181		15/05/2015	1341
20/01/2015	191
21/01/2015	201
22/01/2015	211
23/01/2015	221
24/01/2015	231
25/01/2015	241
26/01/2015	251
27/01/2015	261
28/01/2015	271
29/01/2015	281
30/01/2015	291
31/01/2015	301
01/02/2015	311
02/02/2015	321
03/02/2015	331
04/02/2015	341
05/02/2015	351
06/02/2015	361
07/02/2015	371
08/02/2015	381
09/02/2015	391
10/02/2015	401
11/02/2015	411
12/02/2015	421
13/02/2015	431
14/02/2015	441
15/02/2015	451
16/02/2015	461
17/02/2015	471
18/02/2015	481
19/02/2015	491
20/02/2015	501
21/02/2015	511
22/02/2015	521
23/02/2015	531
24/02/2015	541
25/02/2015	551
26/02/2015	561
27/02/2015	571
28/02/2015	581
01/03/2015	591
02/03/2015	601
03/03/2015	611
04/03/2015	621
05/03/2015	631
06/03/2015	641
07/03/2015	651
08/03/2015	661
09/03/2015	671
10/03/2015	681
11/03/2015	691
12/03/2015	701
13/03/2015	711
14/03/2015	721
15/03/2015	731
16/03/2015	741
17/03/2015	751
18/03/2015	761
19/03/2015	771
20/03/2015	781
21/03/2015	791
22/03/2015	801
23/03/2015	811
24/03/2015	821
25/03/2015	831
26/03/2015	841
27/03/2015	851
28/03/2015	861
29/03/2015	871
30/03/2015	881
31/03/2015	891
01/04/2015	901
02/04/2015	911
03/04/2015	921
04/04/2015	931
05/04/2015	941
06/04/2015	951
07/04/2015	961
08/04/2015	971
09/04/2015	981
10/04/2015	991
11/04/2015	1001
12/04/2015	1011
13/04/2015	1021
14/04/2015	1031
15/04/2015	1041
16/04/2015	1051
17/04/2015	1061
18/04/2015	1071
19/04/2015	1081
20/04/2015	1091
21/04/2015	1101
22/04/2015	1111
23/04/2015	1121
24/04/2015	1131
25/04/2015	1141
26/04/2015	1151
27/04/2015	1161
28/04/2015	1171
29/04/2015	1181
30/04/2015	1191
01/05/2015	1201
02/05/2015	1211
03/05/2015	1221
04/05/2015	1231
05/05/2015	1241
06/05/2015	1251
07/05/2015	1261
08/05/2015	1271
09/05/2015	1281
10/05/2015	1291
11/05/2015	1301
12/05/2015	1311
13/05/2015	1321
14/05/2015	1331
15/05/2015	1341

[sona_sa]

Hi Peter,

Why you are thinking I am having any session or testing. I am a new developer and trying to learn something.

Here in Input Invoice Date Date is till 1st May 2015 - OutPut is for Apr Month Entire date is available and prior month (Jan / Feb / Mar) -- Monthend Date is coming.

In Fig. 2 --> In Input Invoice Date after 1st May there is Date available for 2nd or 3rd, So Output is for previous month is Monthend Date but for current month entire 3 date is available.

Means whenever if new month come or first day of month is available for current month the it will return Output 1 else output 2.

If maxdate is 1 then return me previous month entire date else return me till date and for previous month - monthend date.

Hope you got my point.

[petter]

Why don't you give credit to some or even one of the experts that have tried to help you yet? You should press LIKE and/or HELPFUL. It seems like you have no better thing to do than wasting peoples time and not even thanking them except for writing "Thanks for the reply" which is not a genuine thank anyway ...

[sona_sa]

   Ok.

[petter]

I am sorry that I need to be so direct and I hope you take it in the spirit it is given - to contribute to learning and for this forum to grow and prosper so people enjoy coming here both practitioners and learners:

You should be respecting other people time and effort. The is #1. #2: I can only judge by what you write and give as feedback - not what you actually are doing at home or work.

And your last answer didn't address my concern that you are making an effort to solve anything yourself - except testing and giving feedback.

You should have a closer look and consideration of forum etiquette and be short and concise. Then when you get a feedback seriously try to incorporate the suggestion into your solution. If you are not successful - then post an update which also shows your contribution towards a solution. Give credit by clicking LIKE and HELPFUL and finally reward someone with ANSWERED. Saying thank you all the time doesn't compensate for that.

If you don't do this - people will not feel that this is a mutual or beneficial interaction between respectful peers. Or even being a experienced to learner interaction that is also rewarding...

I seriously hope you learn a lot of Qlik(View) things but also try to learn and understand that a forum needs to be fueled by enthusiasm and positive but honest efforts and feedback.

Good luck with your learning efforts - in all respects

[ToniKautto]

Just as a note, I have closed you duplicate threads. Please do not re-post the same question multiple times in the future.

My approach to these kind of scenarios is to flag the data during load, so that you can target the required data through a simple set expression. In the attached example you can see that I have added a calendar table, in which I add a flag field to indicate the date ranges that interest me. In the chart object I simple select this flag for the aggregation. In my opinion this is a much simpler approach than building a very complex expression or a calculated dimension. For large data sets the flag approach will be very performance efficient.