Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.