Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks Tresco
here is the attached sample app.
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
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.
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..
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.