Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Previous date value

Hey guys.

I have a question. Is there a way to get in expression the previous date value?

If I have these dates :

21/03/2018

20/03/2018

19/03/2018

17/03/2018

And I would like to have this result

CurrentPrevious
21/03/201820/03/2018
20/03/201819/03/2018
19/03/201817/03/2018
17/03/2018-

Thank you,

Razvan

1 Solution

Accepted Solutions
sunny_talwar

May be try this

=Max({<HIST_DATE = {"$(='<' & Max(HIST_DATE))"}>}HIST_DATE)

Capture.PNG

View solution in original post

15 Replies
Chanty4u
MVP
MVP

try  below in strighttable

=above([Current])

razvan_brais
Creator III
Creator III
Author

Tried this solution in a Text box , but unfortunately it doesn`t work

gerry_hdm
Creator II
Creator II

in the script use this

if(DateCurrent <> previous(DateCurrent), DateCurrent , peek('DatePrevious'  as 'DatePrevious',

qv_testing
Specialist II
Specialist II

try  this in UI

Below(Date)

razvan_brais
Creator III
Creator III
Author

Thank you Gerold , but I specially need this in UI.

Chanty4u
MVP
MVP

try in stright tableabve.PNG

qv_testing
Specialist II
Specialist II

In TextBox, it won't work..

You have to write like in Textbox


=Concat(Aggr(ABOVE(Current), Current),', ')

razvan_brais
Creator III
Creator III
Author

I`m attaching an example.

What I especially want to do , is that I would like to show date as Label for each column.

So , for the first column should be , HIST_DATE(current selected date) , and for the second collumn is previous date.

This is where I want to show previous date

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Do you need something like this?

2018-03-21 08_31_56-QlikView - [C__Users_ES33517470F_Downloads_TestForPreviousDay (2) (1).qvw_].png

Saludos