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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
justcotto
Contributor III
Contributor III
‎2019-04-08 09:50 AM

Chart count substring

I have a data set that includes a pay code.  Each entry can have more than one pay code.  I want to display a count of all pay codes.  But I don't want to create a sub string in the load statement because I don't want a new row created for each instance when the data encounters a record with multiple pay codes.rowcount.PNG

 

countchart.PNG

I tried creating a calculated dimension where =SubField(TCF_LINE_PAY_WEB_CODE, ', ') and then doing an expression Count({<METRIC_VALUE={'TCF'}>}Distinct INTEGRATION_ID). But when I select certain pay codes they don't align. For example, If I click pay code 4 in the chart, pay code 12 is displayed on the pie chart.

 

460 Views
0 Likes
1 Reply
dplr-rn
Partner - Master III
Partner - Master III
‎2019-04-08 10:16 AM

Why not move the TCF_LINE_PAY_WEB_CODE as a separate table and do the subfield in script?
so no duplicate rows of the main table occur
455 Views