Last week_in Qlik Sense

[magdalenatudose]

Hi,

I want to see (a KPI) value from last week, without to select last week, staying in selection from this week.

What function or if condition can I put?

I have in my sheet: years, months and dates from months.

Thank you,

Magdalena

[Chanty4u]

Hi,

Please read this thread you will get the result .Lastweek

[magdalenatudose]

Hi Chanty,

Can you make to me an simple example (for Qlik Sense)?

In conversation "Lastweek" are many things that i don't understand.

Thank you,

Magdalena

[brunobertels]

Hi

Can you post the mesure you want in the KPI so that the community will be abble to adapt it for lastweek

Bruno

[ahaahaaha]

Hi Magdalena,

May be like as at attached file?

Regards,

Andrey

[magdalenatudose]

Hi,

I have in my .xls: week (Date) and values (H) from every week.

I have dimension: week(date)

I want to select this week and to show in a KPI the value from last week.

Thank you!

Sorry, I don't know how to atash the app.

Magdalena

[magdalenatudose]

Hi Andrey,

I don't see your attached file..

Thank you,

Magdalena

[ahaahaaha]

Attached the file again.

Regards,

Andrey

[pathiqvd]

Hi,

Try this will work

=sum({<Date2={">=$(=date(WeekStart(max(Date2)-7)+1,'MM/DD/YYYY')<=$(=date(WeekEnd(max(Date2)-7)+1,'MM/DD/YYYY'))"}>}value)

Regards,

[magdalenatudose]

Hi Andrey,

Thank you!

And if I don't want to make the sum, I want to show only the value, what I will put in front of expression?

Thank you!

Madalena