Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have 'date' and 'sales amount' fields in a Straight table.
Date Sales Amount
19/06/2009 14:20:16 45.00
19/06/2009 15:03:15 120.00
19/06/2009 07:14:14 150.00
15/10/2010 17:21:21 71.00
15/10/2010 08:21:41 115.00
If I want to see the 'sales amount' for a particular year, say 2009…How can I filter it in Chart ??
Thanks
P
Hi.
In the load should use:
load Date, year (Date) as Year, `Sales amount` from table.
And then in the graphic use Yaer as dimension and sum([Sales amount] as expression.
I hope this helps.
Hello Prakash,
For this you normally use Set Analysis or you may also try if(Year = 2009, sum(sales)), however you need to separate year from your actual date. Read the set analysis within the QV help and you should be able to understand it better.
Mama
Hi
Thanks for your reply.
Can you brief me bit more.
Chart having Date & Sales Amount Columns. My question is, If end-user want to see the sales for a particular year., say Year 2008 or 2009 or 2010 in chart ... how can he filter it ??
Thanks
Hi.
In the load should use:
load Date, year (Date) as Year, `Sales amount` from table.
And then in the graphic use Yaer as dimension and sum([Sales amount] as expression.
I hope this helps.
Thanks Sandro !
Your solution working fine ...
In Dimention Expression pls write following code
if(Year='2009',Year)
Olá colega,
segue uma aplicação de exemplo.