topic Re: Current week vs previous week in QlikView

Current week vs previous week

gr_eldred — Tue, 15 Aug 2017 22:59:20 GMT

Good afternoon, I am looking for a way to perform an operation of the current week / previous week of the same year

But I only get 0s out.

I leave an image of the structure of my table

I need to create an indicator that divides the sales of the week / week-1 of the same year.

Example: w2/w1,

w3/w2,

w4/w3. ......

etc..

Someone can help me please.

Re: Current week vs previous week

sunny_talwar — Wed, 16 Aug 2017 00:37:33 GMT

One way would be to use

The As-Of Table

Re: Current week vs previous week

Anonymous — Wed, 16 Aug 2017 01:00:17 GMT

two ways 1) Create the weeks in Master Calendar and expression to achieve this.

2) create variable and expression.

i'll cover #2 because i don't know how your calendar is structured.

vWeekStart "= WeekStart(today(),0,0)" //var today's current week start date(Monday)

vWeekEnd "= WeekEnd(today(),0,0)" //var today's current week end date (Sunday)

vPrevWeekStart "= WeekStart(today(),-1,0)" //var last week's date on Monday

vPrevWeekEnd "= WeekEnd(today(),-1,0)" //var last week's date on Sunday

expression:

=sum({<date={'>=$(vWeekStart)<=$(vWeekEnd)'}>}amount) //sum current week amount

=sum({<date={'>=$(vPrevWeekStart)<=$(vPrevWeekEnd)'}>}amount) //sum previous week amount

current / previous week.

=(sum({<date={'>=$(vWeekStart)<=$(vWeekEnd)'}>}amount))

(sum({<date={'>=$(vPrevWeekStart)<=$(vPrevWeekEnd)'}>}amount)) //current week / previous week

hope this was what you're looking for.

Bon.

Re: Current week vs previous week

qliksus — Wed, 16 Aug 2017 09:07:44 GMT

Considering the view you have and you just want to take the previous week something like the below

Sum(Sales)/Before( Sum(Sales))

Re: Current week vs previous week

gr_eldred — Wed, 16 Aug 2017 15:19:52 GMT

Hello Susant, try with before but only show me "-". Need a division from previous week / week (week / week-1)

Re: Current week vs previous week

gr_eldred — Wed, 16 Aug 2017 15:23:02 GMT

hi,

Weeks I have numerics although I concatene the "w" I need week / week-1

Re: Current week vs previous week

qliksus — Thu, 17 Aug 2017 03:44:29 GMT

Can you post a sample file or the expression you are using ?

Re: Current week vs previous week

raviteja475 — Wed, 03 Jul 2019 11:44:26 GMT

its not working i used count instead of sum and and instead of amount i used no.of.sales

Re: Current week vs previous week

raviteja475 — Wed, 03 Jul 2019 11:45:25 GMT

can you please help me how to find the current week and previous week count of sales