Unstring the Column field and add the total records

[lavanya_gurrapu]

Hi,

Please help for the below issue.

I have a column called KPI and loading data to qliksense. KPI have multiple values like below

KPI1

KPI2;KPI3

KPI3

KPI4;KPI5

KPI4

KPI5

Now i have 6 records. I want to generate Pie chart which shows the count for KPI1 as 1, KPI2 as 2, KPI3 as 2, KPI4 as 2 and KPI5 as 2.Here the column for KPI should unstring add the unstring values and display in Pie chart.

Appreciate your quick response.Let me know if more details are required.

[kumarkp412]

Hi ,

Try to use the subfild function to split the string into multiple rows.Then make the count of kpi, you will arrive the exact count.

Ex: SubField(string ,';') as sub string

Check out these.

Thanks 

Kumar kvp

[lavanya_gurrapu]

I can do in Excel for Substring but if i am using share point as datasource for Qlik sense, the Column is one columns that is KPI.

I have tried using Substring in Load like below

LOAD
Substring(KPI,';',1) as KPI1,

Sunstring(KPI,';',2) as KPI2

This is not working for me.