topic Trendlines Interview Question in QlikView

Trendlines Interview Question

ratnakkumar — Fri, 05 Oct 2018 11:34:30 GMT

Having Months on the X-Axis(Dimension), need to find sales of 3 Cities for the last 3 years using Trendlines... Is it possible? This is an interview Question? Need Help!!

Re: Trendlines Interview Question

Miguel_Angel_Baeyens — Fri, 05 Oct 2018 13:45:02 GMT

I'm not sure that I understood your post. "Sales" must be an expression using an aggregation function, such as Sum() in a chart. Once you have such expression, you can apply trendlines to see the trend.

You can also calculate trends with the functions linest_m() and linest_b(), among others. Check this example: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctio…

I don't know if that is an interview question.

Re: Trendlines Interview Question

datagrrl — Fri, 05 Oct 2018 14:03:24 GMT

The best advice I can offer about interviews: Sometimes not having the correct answer isn't the worst thing, as long as you can tell someone how you would get the answer.

Good luck on your interviews. You found this community and are actively using it, you are already ahead of the game.

Re: Trendlines Interview Question

ratnakkumar — Thu, 11 Oct 2018 08:56:08 GMT

Thank you Randi.. for you time. I think no one can have full knowledge on anything, this is my point of view. If you have got that one you would not have an attitude towards interviews. Please try to provide some input. Otherwise Ignore it.

Re: Trendlines Interview Question

ratnakkumar — Thu, 11 Oct 2018 08:56:54 GMT

Thank you for your input.

Re: Trendlines Interview Question

ratnakkumar — Thu, 11 Oct 2018 09:01:17 GMT

I might have misunderstood the question.. But I will try to get the question right.

Re: Trendlines Interview Question

ratnakkumar — Thu, 11 Oct 2018 09:10:57 GMT

Having stores in 4 Cities. Need to get the sales for the 4 cities & represent Sales in the form of Trendlines. All the 4 Cities share the common X-Axis with Months from Jan to Dec. Need to show the Trend for the last 3 years. Sorry that I posted the Question Wrongly. Apologies.

Re: Trendlines Interview Question

datagrrl — Fri, 12 Oct 2018 21:21:26 GMT

I am not 100% sure I understand the question, but if you want to show only the trend lines and not the actual data, you need to check the invisible box for the Sum(Sales) Expression. As Miguel said, there are a few different ways to get trend lines. The easiest way is to pick one of the options in Qlik and check the invisible box for the data. Otherwise calculate the trend lines yourself using the functions mentioned above.

Show trend line but not line

Good luck on your interview. I know Qlikview better than Qliksense, so it might be different in QlikSense.