Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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 ...
Ok.
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
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.