Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lavanya_gurrapu
Contributor III
Contributor III

Unstring the Column field and add the total records

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.

2 Replies
kumarkp412
Creator II
Creator II

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
Contributor III
Contributor III
Author

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.