topic Re: Date vs Last month same date in QlikView

Date vs Last month same date

Tue, 11 Jun 2013 09:03:07 GMT

Hello,

I'm new to qlikview and i need some help with it.

I have a table with some records with dimension "Date" and "a".

What i want is to get values from dimensions "A" coresponding to same date from last month.

I know how to do this in script, but i want the same result using only expresions in a straight table.

for example:

Records:

Result:

I also attached an example on how to i did it with script .

Tnx in advance for help.

Tue, 11 Jun 2013 10:27:49 GMT

Hiiiii

See the attached file

Hope it helps

in your script

load

DATE(Date#(Date,'DD-MM-YYYY'),'DD/MM/YYYY') AS DATE,

DAY(Date#(Date,'DD-MM-YYYY')) AS Day,

Value

from mytable;

then in straight table--

calculateDimension-- =Aggr(max(DATE),Day)

Expression1--- Aggr(FirstSortedValue(Value,-DATE),Day)

Expression2-- Aggr(FirstSortedValue(Value,DATE),Day)

then outputlike this

Tue, 11 Jun 2013 10:40:40 GMT

if your problem resolved then marked it as either correct or helpful according to your question so that it might be helpful for other developer.

Regards

Vishwaranjan