topic Previous fact front-end in QlikView

Previous fact front-end

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I would like to know how to compare previous facts of a dimension in the front-end.

For exemple, I have a TimeStart and TimeEnd as:

TimeStart TimeEnd

0:10 0:20

0:20 0:30

0:30 0:40

I would like to compare the first row of TimeEnd with the second row of TimeStart to check if there are equal.

I want to verify if each TimeStart corresponds with the above TimeEnd.

For exemple,

TimeStart TimeEnd

0:10 0:20

0:15 0:30

In this exemple, the TimeEnd doesn´t match with the next TimeStart, 0:20<>0:15.

Thank you!

Re: Previous fact front-end

sunny_talwar — Mon, 26 Sep 2016 16:25:54 GMT

Based on the sorting, you would either need above or below functions

If(TimeEnd = Above(TimeStart), ....)

If(TimeEnd = Below(TimeStart), ....)

Re: Previous fact front-end

Anonymous — Tue, 27 Sep 2016 06:39:10 GMT

Thanks for your answer Sunny T,

It´s working but just for few rows.

An example:

TimeStart TimeEnd Above(TimeEnd)

0:10 0:20 -

0:20 0:30 -

0:30 0:40 -

0:40 0:50 0:40

If I have understood the function, the result should be:

TimeStart TimeEnd Above(TimeEnd)

0:10 0:20 -

0:20 0:30 0:20

0:30 0:40 0:30

0:40 0:50 0:40

Re: Previous fact front-end

sunny_talwar — Tue, 27 Sep 2016 17:30:26 GMT

Are there more than one dimension in your table? If there are, then try this

Above(TOTAL TimeEnd)

Re: Previous fact front-end

MarcoWedel — Tue, 27 Sep 2016 21:52:46 GMT

Hi,

maybe creating a flag in the script like:

LOAD TimeStart,

TimeEnd,

TimeStart=Previous(TimeEnd) as flag

From YourSource;

hope this helps

regards

Marco

Re: Previous fact front-end

Anonymous — Wed, 28 Sep 2016 05:27:35 GMT

Exactly!

Thank you very much!