topic Re: How to filter data on the previous week? in App Development

How to filter data on the previous week?

Thierno — Wed, 26 Sep 2018 06:48:29 GMT

Hi everyone !

I solicit your help because it's been over a week that I use Qlik and I have a lot of trouble with the syntax of set analysis. I can not filter my data (which runs from August 2017 to today) weekly.

My goal is to show the sum of the numbers only from last week. Here is the last iteration of my work:

Sum ({$ <semaine = {"= $ (= week (weekstart (today (), -1, first_week_day = 0)))"}>} etat_ok)

"semaine" is a column containing the number of the week (0 -> 53)

Can you tell me what's wrong? Or maybe point me to a document explaining how set analysis works ? or both ?

Re: How to filter data on the previous week?

alexandrakfcosta — Wed, 26 Sep 2018 14:09:57 GMT

Hi,

I think your formula is correct, the only detail is regarding your third parameter on WeekStart function. Instead of using "first_week_day = 0", try to use just the value "0".

The final expression should be something like this:

Sum({$ <semaine = {"= $(=Week(WeekStart(Today(), -1, 0)))"}>} etat_ok)

I hope I could help.

Best,

Alexandra Costa.

Re: How to filter data on the previous week?

Thierno — Wed, 26 Sep 2018 14:31:25 GMT

Hi Alexandra,

tx for responding me,

i tried it but it like it doesn't make the filter.

see :

alexandrakfcosta‌

Maybe there is something i misunderstand.

Best,

Thierno DIALLO

Re: How to filter data on the previous week?

alexandrakfcosta — Fri, 28 Sep 2018 10:48:11 GMT

Hi Thierno,

I just realized that you are using 2 equal signs "=". I should try this way:

Sum({$<semaine = {"$(=Week(WeekStart(Today(), -1, 0)))"}>} etat_ok)

Best,

Alexandra.

Re: How to filter data on the previous week?

MK9885 — Fri, 28 Sep 2018 12:53:03 GMT

Maybe try....

Sum ({$ <Week = {$(=Max(Week)-1)},Date>} etat_ok)

Your Week field should be numeric like 1, ,2 ,3 ....

And use your date field as well.

Re: How to filter data on the previous week?

Thierno — Fri, 28 Sep 2018 12:58:24 GMT

Thanks you all for your help. i had an equal sign more.

Best wishes

Thierno