Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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