topic Re: Can Bar Chart display same when user to select year=2016 month =11 it display ? in QlikView

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

paulyeo11 — Wed, 30 Nov 2016 05:09:11 GMT

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

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

paulyeo11 — Wed, 30 Nov 2016 05:10:03 GMT

my qvw

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

tresB — Wed, 30 Nov 2016 05:38:43 GMT

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

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

paulyeo11 — Wed, 30 Nov 2016 05:57:23 GMT

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

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

tresB — Wed, 30 Nov 2016 06:23:34 GMT

Try expression something like:

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

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

hemanthaanichet — Wed, 30 Nov 2016 06:24:45 GMT

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

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

chinnuchinni — Wed, 30 Nov 2016 06:26:26 GMT

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

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

paulyeo11 — Wed, 30 Nov 2016 06:29:04 GMT

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

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

hemanthaanichet — Wed, 30 Nov 2016 06:30:45 GMT

Hi Paul,

Check my attachment it may be helpful to you

Regards

Hemanth

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

paulyeo11 — Wed, 30 Nov 2016 06:32:45 GMT

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

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

paulyeo11 — Wed, 30 Nov 2016 07:26:49 GMT

Hi Hemanth

Can you pls help to take a look of below link :-

where go wrong with my expression :- Sum({<year= {$(=Only(year)-1)} >},{<rEVENUE={rEVENUE}>}Amount)