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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik-Developer
Creator
Creator

Picking required data from string

Hi Everyone,

I have loaded issues table data from jira to qliksense. For sprint field ,values are loading with big string which is unwanted,shown below.

Below one is the sprint field value for one user story.where user story started in sprint8 and carry forwarded to  sprint 9.

"com.atlassian.greenhopper.service.sprint.Sprint@51c6f9d7[id=2000,rapidViewId=776,state=CLOSED,name=YBS Sprint 8,startDate=2020-07-30T16:00:38.382Z,endDate=2020-08-14T15:59:00.000Z,completeDate=2020-08-17T17:15:41.490Z,sequence=2002,goal=<null>],com.atlassian.greenhopper.service.sprint.Sprint@68327bc3[id=2001,rapidViewId=776,state=CLOSED,name=YBS Sprint 9,startDate=2020-08-17T15:19:40.545Z,endDate=2020-08-26T17:19:00.000Z,completeDate=2020-08-27T16:19:51.655Z,sequence=2004,goal=<null>]".

So from above string i want to pick ,where ever name= YBS Sprint along with sprint number.

For example: 1). For user story 10 ,actual sprint is 8 and carry forward to sprint 9

                    2) . For user stroy 15,actual sprint is 9 and carry forward to sprint 10 and sprint 11

Finaly out put i am expecting is:

Userstory,sprint

10,YBS Sprint8, YBS Sprint9

15,YBS Sprint9, YBS sprint 10, YBS sprint11

Sprint field should come with values separated by comma instead of string, may be in future if sprints is carry forward to another sprint for userstory that sprint also should be separated by comma.

 

Can any one suggest your inputs how to proceed on this...

Thanks in advance.....

 

0 Replies