Unstring the Column field and add the total records
Please help for the below issue.
I have a column called KPI and loading data to qliksense. KPI have multiple values like below
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.