Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
Don't know what the logic for End is, but for Start, do you want to see AI, E, & F? Check attached
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());
.
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?
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)
.
Don't see the Flag that I created, can you share the updated app?
.
What if you add it to this table
.