topic Re: sales comparison by day name in Qlik Learning Discussions

sales comparison by day name

Tue, 23 Sep 2014 16:10:13 GMT

I was wondering if you could tell me, how i would be able to formulate a comperative tablet.

my basic priority is to compare the last year's month sales to the sales we are making the current month.

Although i dont want the comparison to be based strictly on dates for example(1/1/13 -1/1/14) but i want to be based on the day names

for example (monday 1/1/13 - monday 2/1/14).

i would be grateful if you could guide me with the expressions i m supposed to use.

Re: sales comparison by day name

ecolomer — Tue, 23 Sep 2014 16:56:37 GMT

The first thing you need is to establish a standard of comparison. For example, you want to compare the 01/01/2013 to 01/01/2014 or you want to compare on Monday of the week xx with xx Monday of the week of the previous year.

According to the criterion formulas and approach is different

Re: sales comparison by day name

Wed, 24 Sep 2014 07:33:21 GMT

hi enrique thank you for your response.

i want to comparison like that you said Monday of the week xx with xx Monday of the week of the previous year. i think this is the difficult part.

Re: sales comparison by day name

jjordaan — Sat, 03 Jan 2015 15:46:09 GMT

Hi Thanasis,

Did you ever found a solution for this?

Thanks in advance