Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

xyz1
Contributor III

?

.

1 Solution

Accepted Solutions

Re: Compare.

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

24 Replies

Re: Compare.

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
Contributor III

?

.

Re: Compare.

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.

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
Contributor III

?

.

Re: Compare.

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

xyz1
Contributor III

?

.

Re: Compare.

What if you add it to this table

Capture.PNG

xyz1
Contributor III

?

.