This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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
Try to use like below,
You can try this
=Aggr(Above(Sum(Fact)), Territory, SubTerritory, CurDate)
=Aggr(Above(TOTAL Sum(Fact)), Territory, SubTerritory, CurDate)
As long as your load order for CurDate is ascending, this should work for you.
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()?
Maybe there is more basic solution for previous period value, than using BELOW()?
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.
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?
This might be the best way to do it
The As-Of Table