topic Re: SEQUENCE CHART in QlikView

SEQUENCE CHART

hemanthkumar_sm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can you help to build the dynamic chart as per attachment,

Requirement:

when i am having current month (ex: May-18 is i should display complete single row (from May-18 to Jun -16, 24 months data)

when i am having current month -1 (ex: Apr-18 , I should display 2 rows (from Apr-18 to Jun -16 , 23 months data)

similarly when i am having current month -2 (ex-Mar-18, i should display 3 rows ( from Mar-18 to Jun 16 , 22 months data)

same thing will continue for rest of the month.

Re: SEQUENCE CHART

Anil_Babu_Samineni — Thu, 29 Nov 2018 05:05:40 GMT

this can be done using If else condition.

Re: SEQUENCE CHART

hemanthkumar_sm — Thu, 29 Nov 2018 06:57:32 GMT

I Tried and it didn't work for me..

Re: SEQUENCE CHART

Anil_Babu_Samineni — Thu, 29 Nov 2018 08:54:57 GMT

Try this way? Where as MonthNum is in number format not string format for that Month field.

If(MonthNum=Max(TOTAL MonthNum),
Concat({<MonthNum = {">=$(=AddMonths(Max(MonthNum),-24))<=$(=Max(MonthNum))"}>} DISTINCT Date,','),
If(MonthNum=Max(TOTAL MonthNum-1),
Concat({<MonthNum = {">=$(=AddMonths(Max(MonthNum-1),-24))<=$(=Max(MonthNum-1))"}>} DISTINCT Date,',')
))

Re: SEQUENCE CHART

hemanthkumar_sm — Thu, 29 Nov 2018 11:16:13 GMT

Hi Loveisfail,

Still it is not working in my for me :-(.

Re: SEQUENCE CHART

Anil_Babu_Samineni — Fri, 30 Nov 2018 03:34:08 GMT

Can you attach QVW file

Re: SEQUENCE CHART

hemanthkumar_sm — Tue, 04 Dec 2018 09:42:13 GMT