Can Bar Chart display same when user to select year=2016 month =11 it display ?

[paulyeo11]

Hi All

I have a chart 1 , which display correct value. I like to make it also able to display same chart , when user select month = 11 and year = 2016.

The reasons is i have annual sales meeting on Feb 2017 , and during 2017 Feb , i want the chart to display up to 2016 Dec. So i select month = 12 year =2016. , mean it will not display 2017 sales.

Hope some one can advise me how to modify the expression.

Paul

[paulyeo11]

my qvw

[tresesco]

In other word, you want the chart not to show data beyond Dec, 16?

[paulyeo11]

Hi Tres

Yes you are right.

in fact i do this chart in QS , i can create the chart now , in Dec 2016 the chart is what i want. But my meeting is mid Feb , when i present the chart it will appear 2017 data , which is i don't want.

Hope you can advise me.

Paul

[tresesco]

Try expression something like:

Sum({<year,Month, Date={'<=$(=Date(RangeMin(makedate(2016,12),max(Date))))'}>}sales)

[hemanthaanichet · Accepted solution]

Hi Paul,

may be this the output your are in need off i think so

Let me know if you have any queries.

Regards

Hemanth

[chinnuchinni]

hi PAUL,with the exclude of year =2017,you will get your desired charts

[paulyeo11]

Hi Praveen

May i know how to do it in expression ?

Now my expression is sum(sales) , For example  i need to add exclude 2016 , so it will display all bar and not to display 2016 bar.

Paul

[hemanthaanichet]

Hi Paul,

Check my attachment it may be helpful to you

Regards

Hemanth

[paulyeo11]

Hi Hemar

Thank you very much , I think your approach work fine. But then i am looking for one expression approach. As i have many field have similar issue. if there it one expression approach that will save me a lot of time.

Paul