topic Re: How to display two Quarters data in bar chart in QlikView

How to display two Quarters data in bar chart

Wed, 14 May 2014 11:40:51 GMT

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

Re: How to display two Quarters data in bar chart

tresB — Wed, 14 May 2014 11:46:58 GMT

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

Re: Re: How to display two Quarters data in bar chart

Wed, 14 May 2014 12:03:11 GMT

Thanks Tresco

here is the attached sample app.

Re: How to display two Quarters data in bar chart

Wed, 14 May 2014 12:13:14 GMT

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

Re: Re: Re: How to display two Quarters data in bar chart

tresB — Wed, 14 May 2014 12:44:09 GMT

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.

Re: How to display two Quarters data in bar chart

Thu, 15 May 2014 05:02:57 GMT

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..

Re: How to display two Quarters data in bar chart

Thu, 15 May 2014 05:05:29 GMT

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.