topic ? in QlikView

?

xyz1 — Sun, 14 Apr 2019 16:35:57 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 04:39:19 GMT

May be this

Table:

LOAD * INLINE [

Topic, P. Start, A. Start

a, 1-Dec-2017, 22-Dec-2017

b, 23-Nov-2017, 24-Nov-2017

c, 11-Oct-2017, 21-Oct-2017

d, 14-Jan-2018, 17-Jan-2018

e, 12-Feb-2018, 22-Feb-2017

f, 11-Nov-2017, 11-Nov-2017

g, 10-Oct-2017, 13-Oct-2017

h, 1-Jan-2018, 2-Feb-2018

i, 2-Feb-2017, 2-Feb-2017

j, 23-Mar-2017, 24-Mar-2017

k, 22-Apr-2018, 24-Mar-2017

l, 17-Oct-2017, 29-Nov-2017

m, 11-Dec-2017, 30-Nov-2017

n, 12-Feb-2017, 14-Feb-2017

o, 22-Dec-2017, 23-Dec-2017

p, 21-Nov-2017, 30-Nov-2017

]

Where [P. Start] >= QuarterStart(Today()) and [P. Start] <= QuarterEnd(Today()) and [A. Start] >= Today() and [A. Start] <= QuarterEnd(Today());

?

xyz1 — Sun, 14 Apr 2019 16:36:38 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 04:51:17 GMT

You listed this as a scripting question... didn't you need this in the script? Also, this is posted in QlikView, but is this for Qlik Sense?

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 04:55:51 GMT

Create a flag like this

Table:

LOAD *,

If([P. Start] >= QuarterStart(Today()) and [P. Start] <= QuarterEnd(Today()) and [A. Start] >= Today() and [A. Start] <= QuarterEnd(Today()), 1, 0) as Flag;

LOAD * INLINE [

Topic, P. Start, A. Start

a, 1-Dec-2017, 22-Dec-2017

b, 23-Nov-2017, 24-Nov-2017

c, 11-Oct-2017, 21-Oct-2017

d, 14-Jan-2018, 17-Jan-2018

e, 12-Feb-2018, 22-Feb-2017

f, 11-Nov-2017, 11-Nov-2017

g, 10-Oct-2017, 13-Oct-2017

h, 1-Jan-2018, 2-Feb-2018

i, 2-Feb-2017, 2-Feb-2017

j, 23-Mar-2017, 24-Mar-2017

k, 22-Apr-2018, 24-Mar-2017

l, 17-Oct-2017, 29-Nov-2017

m, 11-Dec-2017, 30-Nov-2017

n, 12-Feb-2017, 14-Feb-2017

o, 22-Dec-2017, 23-Dec-2017

p, 21-Nov-2017, 30-Nov-2017

];

and then try this for filter pane

=Aggr(Only({<Flag = {'1'}>} Topic), Topic)

?

xyz1 — Sun, 14 Apr 2019 16:38:03 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 05:14:41 GMT

Don't see the Flag that I created, can you share the updated app?

?

xyz1 — Sun, 14 Apr 2019 16:38:36 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 05:51:08 GMT

What if you add it to this table

?

xyz1 — Sun, 14 Apr 2019 16:39:13 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 06:18:42 GMT

So you are saying that this isn't working?

=Aggr(Only({<Flag = {'1'}>} Topic), Topic)

Would you be able to attach the updated app

?

xyz1 — Sun, 14 Apr 2019 17:05:16 GMT

Re: Compare.

sunny_talwar — Wed, 29 Nov 2017 07:35:46 GMT

Will it be possible to share this file?

Project Portfolio.xlsx

?

xyz1 — Sun, 14 Apr 2019 17:04:14 GMT

Re: Compare.

sunny_talwar — Thu, 30 Nov 2017 02:07:39 GMT

Don't know what the logic for End is, but for Start, do you want to see AI, E, & F? Check attached

?

xyz1 — Sun, 14 Apr 2019 17:04:48 GMT

Re: Compare.

sunny_talwar — Fri, 01 Dec 2017 05:53:09 GMT

How should it be considering them? What is the logic?

?

xyz1 — Sun, 14 Apr 2019 17:03:03 GMT

Re: Compare.

sunny_talwar — Fri, 01 Dec 2017 06:10:17 GMT

Can you tell me which 6 are included?

?

xyz1 — Sun, 14 Apr 2019 17:03:43 GMT