Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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,

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Chart Columms Problem

Albert,

I have it below...

I post the sample app again.

François

15 Replies
Partner
Partner

Re: Chart Columms Problem

Hi Qlik-Test,

Can you send us a sample app ?

It will easier to help you.

François

Not applicable

Re: Chart Columms Problem

Chart test.jpeg

Hi Francois,

Sure, sorry about it,

If you need more information, please let me know.

Albert

Partner
Partner

Re: Chart Columms Problem

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

Not applicable

Re: Chart Columms Problem

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

Chart test.jpeg

Partner
Partner

Re: Chart Columms Problem

Albert,


It's work for me...

See the attached file.

François

Not applicable

Re: Chart Columms Problem

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.

Chart test.jpeg

Partner
Partner

Re: Chart Columms Problem

Albert,

See the attached file 😉

François

Not applicable

Re: Chart Columms Problem

Hi,

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

Thanks in advance,

Albert

Partner
Partner

Re: Chart Columms Problem

Albert,

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

Tell me if it's good with this expression.

François