Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
remedibi
Contributor III
Contributor III

Need help splitting column of data into two columns by filtering on another columns values.

In the below image you can see I am receiving duplicate rows of data for each TP# involved. What I want to do is make two columns called Request SLA and Response SLA (as shown in column C). The data I want to fill the fields with is in Column B. Rather than using a pivot table I thought that maybe there is a easier way by only showing rows where column C is Request SLA then make another field and only show data where the column value is response SLA. I am unsure what the syntax would be in the field expression.

 

2019-06-03 10_05_36-Window.png

6 Replies
bramkn
Partner - Specialist
Partner - Specialist

Field1:
only({<CustomFieldname={"Request*"}>}CustomFieldName)
Field2:
only({<CustomFieldname={"Response*"}>}CustomFieldName)
should work.
remedibi
Contributor III
Contributor III
Author

I am seeing a invalid dimension error when viewing my table. Is this because it is not recognizing one of my fields in the expression? When building the expression it does not show any errors which is great!

Thanks

bramkn
Partner - Specialist
Partner - Specialist

its not a dimension. Create a measure instead.
remedibi
Contributor III
Contributor III
Author

This seems to be tricky. In order for the SLA to show I will need the corresponding value from the CustomFieldName to show as well. The problem is I need both values to appear on the same row of data. But doing so at the moment I believe I would need both SLA CustomFieldNames to be present on the report at the same time as well.

 

remedibi
Contributor III
Contributor III
Author

Is it maybe possible to do a similar for XML path type of function?
bramkn
Partner - Specialist
Partner - Specialist

ah you want the data with the name whoops:
Request SLA:
only({<CustomFieldname={"Request*"}>}CustomFieldData)
Response SLA:
only({<CustomFieldname={"Response*"}>}CustomFieldData)