selected period vs selected period

[#1]

Hi,

I want to create a table in which i can compare 2 selected periods.

for example i have 6 years: 2003-2008

I want to compare the total deliveries of 2003-2005 versus the total deliveries of 2006-2008.

so it will be represented in the following table:

                         Year2003-2005     |     Year 2006-2008

Deliveries                    500                              600

Is this possible to create? i can compare every year seperate but i want to have totals on selected periods.

[Gysbert_Wassenaar]

If you're using QV11 you can use alternate states to do this. See attached qvw for a simple example.

[AbhijitBansode]

make use of Alternate States.

To know about how to use it, refer below links:

http://qlikboard.com/2012/12/04/set-analysis-alternate-states-quick-tip/

http://community.qlik.com/thread/49804

Hope this helps..

Regards,

Abhijit

[#4]

IF(MATCH(YEAR,'2003','2004','2005'),Deliveries) AS Year2003-2005

IF(MATCH(YEAR,'2006','2007','2008'),Deliveries) AS Year2006-2008

[#5]

I will try the Alternate States. I think that is the solution. because the periods i want to compare will be variable.

[#6]

Ok This works. Now i want to make it a little bit harder. Same Principle. 2 selected periods compared.

                                  Year2003-2005     |     Year 2006-2008

                Deliveries                    500                              600

Yellow     Sold                             360                            400

               Throw Away                400                            450

               Deliveries                     500                            600

Blue        Sold                             308                            400

               Throw Away                 400                           450

               Deliveries                    500                             600

Red         Sold                            700                            400

               Throw Away                800                            450

[Gysbert_Wassenaar]

Create a pivot table with the same expressions as before and with the two dimensions that contain the values Yellow/Blue/Red and Deliveries/Sold/Throw/Away

[#8]

I cant get it to work. See attachment

[Gysbert_Wassenaar · Accepted solution]

Ah, those aren't dimensions, but expressions. See attached qvw.

[#10]

Yes this is exactly what i needed.