topic Re: Previous date value in QlikView

Previous date value

razvan_brais — Wed, 21 Mar 2018 06:59:15 GMT

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

Current	Previous
21/03/2018	20/03/2018
20/03/2018	19/03/2018
19/03/2018	17/03/2018
17/03/2018	-

Thank you,

Razvan

Re: Previous date value

Chanty4u — Wed, 21 Mar 2018 07:03:39 GMT

try below in strighttable

=above([Current])

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 07:07:47 GMT

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

Re: Previous date value

gerry_hdm — Wed, 21 Mar 2018 07:11:28 GMT

in the script use this

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

Re: Previous date value

Nagaraju_KCS — Wed, 21 Mar 2018 07:11:31 GMT

try this in UI

Below(Date)

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 07:13:30 GMT

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

Re: Previous date value

Chanty4u — Wed, 21 Mar 2018 07:14:06 GMT

try in stright table

Re: Previous date value

Nagaraju_KCS — Wed, 21 Mar 2018 07:14:09 GMT

In TextBox, it won't work..

You have to write like in Textbox

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

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 07:22:01 GMT

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

Re: Previous date value

fvelascog72 — Wed, 21 Mar 2018 07:33:31 GMT

Hi,

Do you need something like this?

Saludos

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 07:36:00 GMT

Kind of ,

But with only two columns : Current date(the date I select) , and Previous date ( previous date for selected date)

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 09:29:20 GMT

Do you have the solution?

Re: Previous date value

fvelascog72 — Wed, 21 Mar 2018 09:30:45 GMT

Hi,

Try in expression:

sum({<HIST_DATE = {'>=$(=Date(Only(HIST_DATE)-1))'}>}Value)/1000

Saludos.

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 09:35:09 GMT

I don`t need values for each KPI for previous day. I need to put as column header , Previous Date for previous values.

HIST_DATE - 1 won`t work because there is a gap between 26 and 24.

When I select 26 , the previous DATE should be 24 not 25

Re: Previous date value

sunny_talwar — Wed, 21 Mar 2018 09:47:38 GMT

May be try this

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

Re: Previous date value

razvan_brais — Wed, 21 Mar 2018 09:50:22 GMT

This is perfect.

Many thanks