topic Re: Compare last week to current week in QlikView

Compare last week to current week

Tue, 23 Dec 2014 09:18:33 GMT

Hi All.

I'm having a problem while trying to implement the following request:

let's say I have the following fields:

Store name

Number of sold Items

Week number.

I want to display in a straight table the 5 bottom stores that sold Items last week (count (Number of sold Items)>0 )

but on the current week which was selected they sold nothing or much less items.

Can someone please Advise?

thanks.

consenit — Tue, 23 Dec 2014 13:15:06 GMT

Hi there.

Have a look at the document attached.

Kind regards,

Ernesto.

Anonymous — Tue, 23 Dec 2014 14:44:22 GMT

Hello,

maybe you can use [Store name] as dimension and the following expression (if you want to display sum of number, otherwise you cab use count):

if(count({<WEEK={"$(=$(vWeek)-1)"}>}NUMBER)>0 and (count(NUMBER)=0 or IsNull(count(NUMBER))), sum({<WEEK={"$(=$(vWeek)-1)"}>}NUMBER))

In dimesion limit tab you can set how many stores display in the dimension

Hope this helps, Elena

Anonymous — Tue, 23 Dec 2014 17:44:03 GMT

Sorry, I forgot a detail:

vWeek= GetFieldSelections(WEEK) where WEEK is your Week number.

And NUMBER is your Number of sold Items.

Wed, 24 Dec 2014 08:57:41 GMT

thanks you so much!

Wed, 24 Dec 2014 08:57:54 GMT

Thank you!!!

anbu1984 — Wed, 24 Dec 2014 09:11:47 GMT

To calculate difference current and last week, you can use Column(2) - Column(1)