topic Re: Chart Columms Problem in QlikView

Chart Columms Problem

Sat, 24 Jan 2015 11:25:12 GMT

Hello everyone,

I have a small problem and I don´tt know how to fix it, I hope you can help me.

I have a table with three columns,

1. Name

2. Number of months

3.Years

I created a Chart name based on the size and the expression Sum ([MONTH])

I wan to display only the names from a given year, 2009 or 2010.....

Any ideas?

Thank You,

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 11:27:02 GMT

Hi Qlik-Test,

Can you send us a sample app ?

It will easier to help you.

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 11:56:31 GMT

Hi Francois,

Sure, sorry about it,

If you need more information, please let me know.

Albert

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 13:31:03 GMT

Albert,

I don't understand what do you analyse...

But this expression below is maybe good for you :

Sum({<YEAR={2010}>} Month)

More information about set analysis (by Fabrice Aunez): Set Analysis: syntaxes, examples

It's what do you expect ?

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 13:45:21 GMT

Hi again,

i want to have a chart that show the information from one year. In teory it is a easy thing.....

Your expression is not working (but it is the thing that i am looking for)

With it expression the result is

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 13:52:46 GMT

Albert,

It's work for me...

See the attached file.

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 14:01:51 GMT

Hi again,

I found half of the problem (the Month name). Now i can see only one year, but i need to see all the years from 2010.

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 14:07:33 GMT

Albert,

See the attached file 😉

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 14:19:05 GMT

Hi,

Sorry but I can not open your file. can you please tell me the expression?

Thanks in advance,

Albert

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 14:25:43 GMT

Albert,

=Sum({<Year={">= 2010"}>} Month)

Tell me if it's good with this expression.

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 14:33:57 GMT

Sorry but is no working, you can see the chart

Only have to show the data from 2010 (Anna , Kely and Frank)

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 14:39:48 GMT

Albert,

I have it below...

I post the sample app again.

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 14:49:36 GMT

Thanks a lot the expression is right , the problem was capital letters =Sum({<YEAR={">= 2010"}>} MONTH)

I have a last question,

Do you know any book about expresions pratice with Qlik view?

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 14:54:30 GMT

Albert,

I'm happy to help you,

I know this physical book : "QlikView 11 for Developers" – November 23, 2012 by Barry Harmsen, Miguel Garcia

To play with Set Analysis :

Set Analysis: syntaxes, examples by Fabrice Aunez

Set Analysis by Geeta Alhan

François

Re: Chart Columms Problem

Sat, 24 Jan 2015 15:00:13 GMT

Thanks a lot, I will check it.

Re: Chart Columms Problem

francoiscave — Sat, 24 Jan 2015 15:04:41 GMT

Albert,

Your welcome,

Have fun with QlikView.

PS. Can you close the spanish version of your question ?

Thanks a lot,

François