topic Re: Compare two time periods in QlikView

Compare two time periods

Mon, 05 Jan 2015 22:47:46 GMT

Hello,

I need to ask for assistance with how to create script for comparing two time periods. Here's what I'm hoping to do...

I would like the end user to be able to select what data comparisons they need to see. Here are examples of some of the comparisons the end user may want to do:

1) Compare cost for "Q2 for Y1" to "Q1 for Y1" (i.e. Q2 2014 in one column and Q1 2014 in another column)

2) Compare "Q2 for Y1" to "Q2 for Y2" (i.e. Q2 2014 in one column and Q2 2013 in another column)

3) Compare two consecutive months.

4) Compare a month between two years

5) Compare 6 months from one year to 6 months from another year

Basically I need to create flexibility where the end user can choose how they look at the data. I can keep it to a few choices if that's easier.

Critical choices to include:

1) Consecutive month over month.

2) Consecutive quarter over quarter

3) Consecutive year over year

4) 6 months over previous year's same 6 months.

Is there standard script that I can add?

Thank you, thank you, thank you in advance:)

Re: Compare two time periods

Josh_Good — Mon, 05 Jan 2015 23:13:12 GMT

Hi Barb,

To give the maximum flexibility to the users I would recommend using alternate states. This will allow the users to select any date and compare it to any other data. The disadvantage of this approach is it give so much choice so you may want to create buttons that jump to specific selections. Here is an example of both.

-Josh

Qlik

Re: Compare two time periods

Tue, 06 Jan 2015 15:06:24 GMT

Hi Josh - I am not seeing your examples. Did you mean to include a file?

Re: Compare two time periods

Josh_Good — Tue, 06 Jan 2015 15:08:57 GMT

Hi Barb,

Are you not seeing a QVW attached to my post? (I'm seeing it when I look at the posting).

-Josh

Re: Compare two time periods

Tue, 06 Jan 2015 15:29:35 GMT

I don't see it with your original reply but I see it here with this reply. Weird. I will take a look.

As a side note...I recently implemented your Master Calendar example...the one where you posted a video. Oh my gosh you are so incredibly helpful. THANK YOU!!!! I am completely learning QlikView on my own and have no prior experience with any of this so I rely on the Qlik Community a lot. Since I have your ear I wanted to just let you know that I really appreciate your assistance and expertise and you definitely make an impact in the Qlik Community. You're awesome!

Re: Compare two time periods

Tue, 06 Jan 2015 15:31:24 GMT

...and oh shoot...I just realized the file I saw copied in your last post is just a screen shot. I still am unable to see and click on the file attachment.

Re: Compare two time periods

Josh_Good — Tue, 06 Jan 2015 15:36:50 GMT

very strange... Here is a Dropbox link

Dropbox - dates.qvw

-Josh

Re: Compare two time periods

Tue, 06 Jan 2015 15:38:44 GMT

This is what I see

Re: Compare two time periods

Tue, 06 Jan 2015 15:39:18 GMT

Hi Barb,

-Josh

Qlik

Re: Compare two time periods

Mon, 02 Mar 2015 08:18:38 GMT

Josh, I see that you have to select Alternate State as DateCompare. How does this work if I'd like to compare two different product groups?

Re: Compare two time periods

Josh_Good — Tue, 03 Mar 2015 00:18:30 GMT

Toni,

There isn't any difference to set this up for a different dimension. Using the alternate state "DateCompare" is a completely arbitrary name I gave the state (it is not a special word or anything). So when you create your alternate states you can give them any name you'd like.

-Josh

Qlik

Re: Compare two time periods

Thu, 12 Mar 2015 15:11:30 GMT

Thank you Josh!