Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
hemanthkumar_sm
Partner - Contributor
Partner - Contributor

SEQUENCE CHART

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.

 

6 Replies
Anil_Babu_Samineni

this can be done using If else condition.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
hemanthkumar_sm
Partner - Contributor
Partner - Contributor
Author

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

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,',')
))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
hemanthkumar_sm
Partner - Contributor
Partner - Contributor
Author

Hi Loveisfail,

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

 

Anil_Babu_Samineni

Can you attach QVW file
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
hemanthkumar_sm
Partner - Contributor
Partner - Contributor
Author