topic Data based on month selection in QlikView

Data based on month selection

balaji_m — Wed, 14 Mar 2018 15:21:12 GMT

Dear Experts,

Please help us on this below request

I have date and count (records) for particular date.

when I select dec 2017 I will get one month date i.e 1st Dec 2017 to 31st Dec 2017 based on below screenshot.

My out put should show additional one bar with 1-Jan-2018 date and corresponding value.

it should show all the months based on use selected month.

i.e...if user selected June 2017.it should show 1-jun-2017 to 1-July-2017.

Regards,

Balaji

Re: Data based on month selection

MK_QSL — Wed, 14 Mar 2018 15:27:21 GMT

Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

Re: Data based on month selection

isingh30 — Wed, 14 Mar 2018 15:28:29 GMT

Can you share your data or app?

Re: Data based on month selection

balaji_m — Wed, 14 Mar 2018 18:10:15 GMT

Hi Ishtdeep,

Please find data below:I need to apply monthwise filter.

Date	Val
1-Jan-18	173
2-Jan-18	2091
3-Jan-18	5324
4-Jan-18	4800
5-Jan-18	2430
6-Jan-18	15
7-Jan-18	41
8-Jan-18	2521
9-Jan-18	2534
10-Jan-18	2755
11-Jan-18	2620
12-Jan-18	2165
13-Jan-18	30
14-Jan-18	23
15-Jan-18	1652
16-Jan-18	3181
17-Jan-18	3708
18-Jan-18	2314
19-Jan-18	2827
20-Jan-18	58
21-Jan-18	308
22-Jan-18	3971
23-Jan-18	3352
24-Jan-18	3545
25-Jan-18	3145
26-Jan-18	807
27-Jan-18	24
28-Jan-18	457
29-Jan-18	8444
30-Jan-18	5958
31-Jan-18	3089
1-Feb-18	2091
2-Feb-18	5324
3-Feb-18	4800
4-Feb-18	2430
5-Feb-18	15
6-Feb-18	41
7-Feb-18	2521
8-Feb-18	2534
9-Feb-18	2755
10-Feb-18	2620
11-Feb-18	2165
12-Feb-18	30
13-Feb-18	23
14-Feb-18	1652
15-Feb-18	3181
16-Feb-18	3708
17-Feb-18	2314
18-Feb-18	2827
19-Feb-18	2091
20-Feb-18	5324
21-Feb-18	4800
22-Feb-18	2430
23-Feb-18	15
24-Feb-18	41
25-Feb-18	2521
26-Feb-18	2534
27-Feb-18	2755
28-Feb-18	2620
1-Mar-18	2165
2-Mar-18	30
3-Mar-18	23
4-Mar-18	1652
5-Mar-18	3181
6-Mar-18	3708
7-Mar-18	2314
8-Mar-18	2827
9-Mar-18	58
10-Mar-18	308
11-Mar-18	3971
12-Mar-18	3352
13-Mar-18	3545
14-Mar-18	3145
15-Mar-18	807
16-Mar-18	2091
17-Mar-18	5324
18-Mar-18	4800
19-Mar-18	2430
20-Mar-18	15
21-Mar-18	41
22-Mar-18	2521
23-Mar-18	2534
24-Mar-18	2755
25-Mar-18	2620
26-Mar-18	2165
27-Mar-18	30
28-Mar-18	23
29-Mar-18	1652
30-Mar-18	3181
31-Mar-18	3708
1-Apr-18	2314
2-Apr-18	2827
3-Apr-18	58
4-Apr-18	308
5-Apr-18	3971
6-Apr-18	3352
7-Apr-18	3545
8-Apr-18	3145
9-Apr-18	807
10-Apr-18	24
11-Apr-18	2091
12-Apr-18	5324
13-Apr-18	4800
14-Apr-18	2430
15-Apr-18	15
16-Apr-18	41
17-Apr-18	2521
18-Apr-18	2534
19-Apr-18	2755
20-Apr-18	2620
21-Apr-18	2165
22-Apr-18	30
23-Apr-18	23
24-Apr-18	1652
25-Apr-18	3181
26-Apr-18	3708
27-Apr-18	2314
28-Apr-18	2827
29-Apr-18	58
30-Apr-18	308
1-May-18	3971
2-May-18	3352
3-May-18	3545
4-May-18	2091
5-May-18	5324
6-May-18	4800
7-May-18	2430
8-May-18	15
9-May-18	41
10-May-18	2521
11-May-18	2534
12-May-18	2755
13-May-18	2620
14-May-18	2165
15-May-18	30
16-May-18	23
17-May-18	1652
18-May-18	3181
19-May-18	3708
20-May-18	2314
21-May-18	2827
22-May-18	58
23-May-18	308
24-May-18	3971
25-May-18	3352
26-May-18	2091
27-May-18	5324
28-May-18	4800
29-May-18	2430
30-May-18	15
31-May-18	41
1-Jun-18	2521
2-Jun-18	2534
3-Jun-18	2755
4-Jun-18	2620
5-Jun-18	2165
6-Jun-18	30
7-Jun-18	23
8-Jun-18	1652
9-Jun-18	3181
10-Jun-18	3708
11-Jun-18	2314
12-Jun-18	2827
13-Jun-18	58
14-Jun-18	308
15-Jun-18	3971
16-Jun-18	3352
17-Jun-18	3545
18-Jun-18	2091
19-Jun-18	5324
20-Jun-18	4800
21-Jun-18	2430
22-Jun-18	15
23-Jun-18	41
24-Jun-18	2521
25-Jun-18	2534
26-Jun-18	2755
27-Jun-18	2620
28-Jun-18	2165
29-Jun-18	30
30-Jun-18	23
1-Jul-18	1652
2-Jul-18	3181
3-Jul-18	3708
4-Jul-18	2314
5-Jul-18	2827
6-Jul-18	58
7-Jul-18	308
8-Jul-18	3971
9-Jul-18	3352
10-Jul-18	3545
11-Jul-18	3145
12-Jul-18	807
13-Jul-18	24
14-Jul-18	2091
15-Jul-18	5324
16-Jul-18	4800
17-Jul-18	2430
18-Jul-18	15
19-Jul-18	41
20-Jul-18	2521
21-Jul-18	2534
22-Jul-18	2755
23-Jul-18	2620
24-Jul-18	2165
25-Jul-18	30
26-Jul-18	23
27-Jul-18	1652
28-Jul-18	3181
29-Jul-18	3708
30-Jul-18	2314
31-Jul-18	3181

Re: Data based on month selection

balaji_m — Wed, 14 Mar 2018 18:12:22 GMT

Hi Manish,

Thanks for your response.

I want to add next month start date should be append end of current selected month...I have to apply monthly filter as well.

Regards,

Balaji

Re: Data based on month selection

isingh30 — Wed, 14 Mar 2018 18:40:51 GMT

You are using which chart? Please check attached screenshot. Let me know.

Re: Data based on month selection

MK_QSL — Wed, 14 Mar 2018 18:42:26 GMT

Like this?

And, this is not the right way to provide sample data. You should have used excel file for providing sample data.

Re: Data based on month selection

isingh30 — Wed, 14 Mar 2018 18:50:55 GMT

Manish please check attached qvw. We are we using expression here when it's coming by default. Please advise.

Thank you!

Re: Data based on month selection

sunny_talwar — Wed, 14 Mar 2018 18:57:55 GMT

I think OP wants to see one extra day worth of data then the selection would show... for example

if Feb 2018 is selected, they want to see Feb 1st to March 1st..... (March 1st won't be part of regular Feb 2018 selection)

Re: Data based on month selection

isingh30 — Wed, 14 Mar 2018 19:03:04 GMT

Thank you

Re: Data based on month selection

MK_QSL — Wed, 14 Mar 2018 19:11:56 GMT

Change my expression as below..

IF(GetSelectedCount(MonthYear),

SUM(

Date = {">=$(=MonthStart(Max(Date)))<=$(=MonthStart(Max(Date),1))"},

MonthYear=

Val),

SUM(Val))

Re: Data based on month selection

MK_QSL — Wed, 14 Mar 2018 19:14:01 GMT

If you want to select more than one MonthYear then use below expression.

IF(GetSelectedCount(MonthYear),

SUM(

Date = {">=$(=MonthStart(Min(Date)))<=$(=MonthStart(Max(Date),1))"},

MonthYear=

Val),

SUM(Val))