Re: Previous period Value - Qlik Community

aisolomatin · ‎2017-06-30

Hi, I'm trying to get the previous value in a straight table.

I've already checked solution with BELOW(), but it requires users sorting table by date and it's doesn't fit, for us.

Here is the table example:

So, if somebody could help I really appreciate.

Thanks in advance, Andrey

devarasu07 · ‎2017-06-30

HI,

Try to use like below,

Above(total sum(Fact))

sunny_talwar · ‎2017-06-30

You can try this

=Aggr(Above(Sum(Fact)), Territory, SubTerritory, CurDate)

or this

=Aggr(Above(TOTAL Sum(Fact)), Territory, SubTerritory, CurDate)

As long as your load order for CurDate is ascending, this should work for you.

aisolomatin · ‎2017-07-03

Sunny, Hi!

Yes, BELOW() works fine if data is ordered by asc.

But if I change load order in script, then it doesn't work, even if I make Load Order by CurDate in script.

That's why I don't want to use BELOW().

Maybe ! there is more basic solution for previous period value, than using BELOW()?

aisolomatin · ‎2017-07-03

Hi, Devarasu!

Yes, BELOW() works fine if data is ordered by asc.

But if I change load order in script, then it doesn't work, even if I make Load Order by CurDate in script.

Maybe there is more basic solution for previous period value, than using BELOW()?

Anonymous · ‎2017-07-03

The Best way I can think of is when you use set analysis. This would solve the issues you would come across later stages in building your app.

aisolomatin · ‎2017-07-03

I've tried this way, but get stucked with issue:

if I add field 'CurDate' to Dimensions, each row in table became looks like this:

Do you have any ideas how to solve it?

sunny_talwar · ‎2017-07-06

This might be the best way to do it