topic Re: Line chart in QlikView

Line chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I want to show last 12 month sales of products based on the top 5 products sold in the current month.

Thanks in advance.

Re: Line chart

Anil_Babu_Samineni — Sat, 21 Jan 2017 20:03:56 GMT

Try like this

Sum({<Products = {'$(=Rank(products)<=5)'}, month = {'$(=AddYears(Max(month),-1))'}>} sales)

Re: Line chart

Sun, 22 Jan 2017 03:57:25 GMT

Hi Anil,

If we use this Formula in an expression it will return only the current month data. I want to show the last 12 month trend of these top products.

Re: Line chart

sunny_talwar — Sun, 22 Jan 2017 18:47:59 GMT

May be like this:

Sum({<Products = {"=Rank(Sum({<MonthYear = {'$(=Date(Max(MonthYear)))'}>}Sales)) < 6"}, MonthYear = {"$(='>=' & Date(MonthStart(Max(MonthYear), -12)) & '<=' Date(Max(MonthYear)))"}>} Sales)

Here, create MonthYear field in the script like this

LOAD TempDate,

Date(MonthStart(TempDate)) as MonthYear

FROM ....

Re: Line chart

rahulpawarb — Mon, 23 Jan 2017 05:20:34 GMT

I like the way you derive solution... The most simplified form..

Re: Line chart

Anil_Babu_Samineni — Mon, 23 Jan 2017 05:35:38 GMT

Would you mind, Please share the application?

Re: Line chart

sunny_talwar — Mon, 23 Jan 2017 10:08:08 GMT