Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Comparing Quarterly results for 3 different years

Hi,

I need suggestion how to create a comparison between 3 quarters in 4 years. So example i want to display a chart to compare the Quarter2 sales for year 2010, 2011, 2012 and 2013.

Thank you very much in advance for your kind advice.

Tags (1)
4 Replies
MVP
MVP

Re: Comparing Quarterly results for 3 different years

May be something like this:

Take Year as a dimension in a straight table and expression like:

=Sum(Amount)

Now allow user to select a specific quarter.

If it's not that simple you feel, please share your sample app.

Not applicable

Re: Comparing Quarterly results for 3 different years

Are you able to advise what does the below parameter means:

1) Base Expression

2) Timestamp Expression

3) Basedate Expression

Thanks..

Jeremiah Lee

Product Manager for eWindow®, Global Trading Services

Platts

12 Marina Boulevard

#23-01, Marina Bay Financial Centre Tower 3

Singapore 018982

DID (65) 6530 6415 | Support (65) 6530 6530

Mobile (65) 9108 4192 | F (65) 6532 2700

Yahoo : jleeka75@yahoo.com<mailto:jleeka75@yahoo.com>

www.platts.com<http://www.platts.com/>

eWindow Helpline

ewindow@platts.com<mailto:ewindow@platts.com>

+65 6530.6530 Singapore

+44 20 7176.6333 London

+1 713 655.2222 Houston

Find out more about Platts Oil Methodology Explained Sessions<http://marketing2012.platts.com/content/OLGL2013OM_MethodologyTraining?mvr=eventlisting> in Houston, Singapore and London, or visit the On Demand Session<http://www.plattsmethodology.com/>

MVP
MVP

Re: Comparing Quarterly results for 3 different years

Possibly you are talking about time chart. Help says:

Base Expression

Type an expression defining the measure you want to study, e.g. sum(Sales).

Timestamp Expression

State an expression (or just a field name) indicating the location of a timestamp (typically a date) associated with each transaction, e.g. OrderDate.

Basedate Expression

Type an expression providing the reference in time towards which all transaction timestamps should be compared, e.g. today().

Hope it helps. One more point, it is always recommended to close the existing thread and create a new one if you have got the answer to earlier, This way your query would get proper attention.  

Not applicable

Re: Comparing Quarterly results for 3 different years

Or use set analysis.

sum({year='2011'} sales) and use quarter as dimension. This way you'll see the 4 lines in one chart. If you get that working then replace the hardcoded year with an expression, i.e. so you'll always display the last 4 years.

As with your other query, I need more info.

1) Base Expression

2) Timestamp Expression

3) Basedate Expression

Typically a timestamp is more detailed than a date, maybe you need an expression to convert times in your script?

Community Browser