topic Re: Breaking the Trelis Charts in QlikView

Breaking the Trelis Charts

Wed, 05 Nov 2014 04:25:58 GMT

I have number of trelis charts and want only to display only the Facilities which have admission figures trending downward ones only.

Appreciate if you could help me.

I have attached the .QVW. Thanks very much for your help.

Re: Breaking the Trelis Charts

Gysbert_Wassenaar — Wed, 05 Nov 2014 09:02:37 GMT

See attached qvw.

Re: Breaking the Trelis Charts

Wed, 05 Nov 2014 23:16:30 GMT

Hi Gysbert

Thanks for that.

I only want the charts which are trending down, since I can see there the trending up ones.

Thanks

Flavian.

Re: Breaking the Trelis Charts

Wed, 05 Nov 2014 23:19:25 GMT

Hi Gysbert

Thanks. I have responded to the blog.

Appreciate if you could respond to it.

Thanks

Flavian

Re: Breaking the Trelis Charts

Gysbert_Wassenaar — Thu, 06 Nov 2014 14:15:33 GMT

My mistake, I misread your requirements. Change the >0 into <0:

only({<Facility={'=LINEST_M(Actuals,Month)<0'}>}Actuals)

Re: Breaking the Trelis Charts

Fri, 07 Nov 2014 00:33:14 GMT

Hi Gysbert,

Thanks very much. It worked. Also appreciate if you could let me know only to "display the charts of the Actual values which are greater than some value - say 400 for the months selected" so that low valued charts will not be displayed.

Thanks

Flavian