topic Re: Re: Re: Trendline dissapears while making a selection in QlikView

Trendline dissapears while making a selection

bell_byloli — Wed, 19 Feb 2014 11:27:43 GMT

hello all,

i have a combo chart which shows the last 6 months revenue based on the latest month . Dimensions are Month and region(Asia, europe and america), the chart is plotted expressions of revenue for bar chart and a line . however in default view, based on expression

sum ({<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"}>} (revenue))

i am able to view the trendline. However when i make a selection of the month , the chart shows the 6 months data from the month selected, however it does not show the trendline, it just shows a symbol over the selected month(diamond).

Please Can any one suggest how we can view the trendline for any selection.

Re: Trendline dissapears while making a selection

Nicole-Smith — Wed, 19 Feb 2014 13:48:30 GMT

Try adding a 1 into the set analysis in order to ignore the selection:

sum ({1<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"}>} (revenue))

Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 05:55:34 GMT

thanks Nicole , i tried this option but i am still unable to the get the trendline when selecting a month

Re: Trendline dissapears while making a selection

sujeetsingh — Thu, 20 Feb 2014 06:12:15 GMT

Try using if statement

Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 06:55:39 GMT

hey Sujeet thanks , i am not sure if i follow your method.Could please provide an example.

Re: Trendline dissapears while making a selection

sundarakumar — Thu, 20 Feb 2014 07:11:16 GMT

Hi Belliappa,

R u using single expression to show both line and chart or two different expressions?

and Plese check in which field( "Month" or "Month new year") u r making the month selection?
Please try to post a sample or screen shot of ur chart and expression tab...

-Sundar

Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 08:29:46 GMT

hello Sundarkumar, i have uploaded a sample file.

Re: Re: Trendline dissapears while making a selection

sundarakumar — Thu, 20 Feb 2014 09:43:53 GMT

Hi Belliappa,

PFA.

It is working now.

-Sundar

Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 10:14:29 GMT

Thanks so much Sundarakumar..!

Re: Re: Trendline dissapears while making a selection

sundarakumar — Thu, 20 Feb 2014 10:49:32 GMT

Hi Belliappa,

While working on your app, i did some changes for calculating the dimension, hope it will help your development.

PFA.

Hope this helps.

-Sundar

Re: Re: Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 11:13:12 GMT

hello Sundarakumar , thank you so much for your help, i have a smiliar issue with one more chart please find it attached. here i am trying to calculate the servie levels. it doesnt seem to work.

aggr(count ({1<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"},[servicelevel]={1}>} [servicelevel])/

count ({1<Year=,Quarter=,Month=,MonthYearNew={">=$(=addmonths(max(MonthYearNew),-5)) <=$(=Max(MonthYearNew))"}>} [servicelevel]),Month)

Re: Re: Re: Trendline dissapears while making a selection

bell_byloli — Thu, 20 Feb 2014 11:24:13 GMT

sorry i overlooked something. it works perfectly fine. Thank you for the help.

Re: Re: Re: Trendline dissapears while making a selection

sundarakumar — Thu, 20 Feb 2014 11:25:34 GMT

Ok thanks..