How to display two Quarters data in bar chart

[#1]

Hi all,

I am 10 days old to Qlikview and I have the below data::

Quarter Name	Start date	End date	Quantity
2014-Q4	2014-03-30	2014-06-28	1000
2014-Q3	2013-12-29	2014-03-29	800
2014-Q2	2013-09-29	2013-12-28	600

If I select 2014-Q4..I am able to display 2014-Q4 data by using the expression "Sum(Quantity)".

Now, my requirement is if I click on 2014-Q4, I want to display both 2014-Q4 and 2014-Q3 data on bar chart.Or if i click on 2014-Q3 i want to display 2014-Q3 and 2014-Q2.

Thanks in advance,

Bharath

[tresesco]

It depends on your quartername data format. Try to share your sample app, you would get answer faster. See:

Preparing examples for Upload - Reduction and D... | Qlik Community

[#3]

Thanks Tresco

here is the attached sample app.

[#4]

Hi Bharatt

you can make itby set analysis.

To make it simple it is better to store a specific field which links with quarter. Let's say something like

Quarter 2014-Q4

QuarterDate 01/12/2014  as format date

Then when you clikc in your list box to 2014-Q4  you will set 2 expressions

expr 1  sum(Quantity)

expr 2 sum({<QuarterDate={max(addmonths(QuarterDate,-3))}>} Quantity)  will give the result stored under 01/09/2014 means Q3-2014

best regards

Chris

[tresesco]

May be like attached sample.

Usually, it is better to create such fields(like Quarter Name) using  proper date function in the script or using Dual(). That helps simplify front end calculations.

[#6]

Hi tresesco,

i just realized, i cant open the file as I am using the Personal edition.

Could you please provide step by step..I am so sorry for the trouble..

[#7]

Hi,

not sure how to do it..

I tried this one..but not working..

sum({<[Start date]={max(addmonths([Start date],-3))}>} Quantity).

not sure wats the issue..

If you dont mind can you give me step by step details.Sorry for the trouble.

thanks in advance.