Filter in Chart ??

[#1]

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

[#2]

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

[#3]

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

[spividori · Accepted solution]

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.

[#5]

Thanks Sandro !

Your solution working fine ...

[suniljain]

In Dimention Expression pls write following code

if(Year='2009',Year)

[#7]

Olá colega,

segue uma aplicação de exemplo.