Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart Columms Problem

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,

15 Replies
Not applicable
Author

Sorry but is no working, you can see the chart

Chart test.jpeg

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

francoiscave
Partner - Creator III
Partner - Creator III

Albert,

I have it below...

I post the sample app again.

François

Not applicable
Author

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?

francoiscave
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

Thanks a lot, I will check it.

francoiscave
Partner - Creator III
Partner - Creator III

Albert,

Your welcome,

Have fun with QlikView.

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

Thanks a lot,

François