# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for
Did you mean:
Creator

## Set analysis - sum of last 30 days

Qlik experts,

I do know that this question has been asked several times here on the community, but I just can’t get it to work.

I would like to use a KPI to show a measure of the last 30 days. I have used this expression:

sum({<ElementID= {'RR'}, Dato = {">\$(=Dato(Today()-30))"}>}[Vaerdata.Verdi])

Dato is my date filed (Norwegian)

The problem is that the expression does not show the last 30 days, but the entire record of data (several years).

And is there a post or blog where I can read more about how to use Date-function in Qlik sense?

Cheers

Helge

Here is the Calander-script that I use:

QuartersMap:

rowno() as Month,

'Q' & Ceil (rowno()/3) as Quarter

AUTOGENERATE (12);

Temp:

Min(Dato) as minDate,

max(Dato) as maxDate

Resident Vaerdata;

Let varMinDate = Num(Peek('minDate', 0, 'Temp'));

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

DROP Table Temp;

TempCalendar:

\$(varMinDate) + Iterno()-1 As Num,

Date(\$(varMinDate) + IterNo() - 1) as TempDate

AutoGenerate 1 While \$(varMinDate) + IterNo() -1 <= \$(varMaxDate);

MasterCalendar:

TempDate AS Dato,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

Day(TempDate) As Day,

ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

1 Solution

Accepted Solutions
Creator II

Hi PFA,

Your field is in TimestampFormat, I guess you will have to change it to DateFormat.

Thanks,

RT

16 Replies
Specialist II

H,

please try below ,also let us know Dato format.

sum({<ElementID= {'RR'}, Dato = {">=\$(=Dato (max(today())-30, 'DD/MM/YYYY'))"}>}[Vaerdata.Verdi])

Creator II

Hi,

Should it not be -

sum({<ElementID= {'RR'}, Dato = {">\$(=Date(Today()-30))"}>}[Vaerdata.Verdi])  ?

Thanks,

RT

Luminary

Hi!

Is Dato your date field? Maybe go like this:

sum({<ElementID={'RR'}, Dato={">\$(=Date(Today()-30))"}>}[Vaerdata.Verdi])

vizmind.eu
Creator

But it is not

sum({<ElementID= {'RR'}, Dato = {">\$(=Date(Today()-30))"}>}[Vaerdata.Verdi])

?

Creator
Author

Dato-format is my date format (Norwegian). I have updated the post with more information.

Your expression gives the sum of the enitre record (several years)

Thanks

HJ

Creator
Author

Sorry, it does not work - it gives my a value of 0.

Thanks

HJ

Creator
Author

Dato is my date filed.

Your expression gives me a value of 0.

Thanks

HJ

Creator
Author

Sorry, byt your expression gives me a value of 0.