topic Filter in Chart ?? in QlikView

Filter in Chart ??

Fri, 28 Jan 2011 17:31:25 GMT

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

Filter in Chart ??

Fri, 28 Jan 2011 17:35:19 GMT

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

Filter in Chart ??

Fri, 28 Jan 2011 17:45:56 GMT

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

Filter in Chart ??

spividori — Fri, 28 Jan 2011 20:52:31 GMT

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.

Filter in Chart ??

Tue, 01 Feb 2011 18:15:54 GMT

Thanks Sandro !

Your solution working fine ...

Filter in Chart ??

suniljain — Tue, 01 Feb 2011 19:05:26 GMT

In Dimention Expression pls write following code

if(Year='2009',Year)

Filter in Chart ??

Tue, 01 Feb 2011 21:09:25 GMT

Olá colega,

segue uma aplicação de exemplo.