Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In QlikView I can show the numbers in the legion as below.
How can I do this in qlik sense?
Thank You,
Michael
Hello,
Perhaps you can follow this approach:
1. I have the following load statement:
Data:
load * inline [
Product
Product A
Product B
Product B
Product C
];
2. Then I have created a table with the counts of the product:
CountTable:
load
Product as Product,
Count(Product) as Count
Resident Data Group By Product;
3. In sheet, I have created a Pie Chart
4. I have added as measure the expression =Count(Product)
5. And as dimension I have added the expression =Product & ' ' & Count
6. The outcome is:
As you can see the legend displays the product names and near each product name it displays the count value for each product.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hello,
Perhaps you can follow this approach:
1. I have the following load statement:
Data:
load * inline [
Product
Product A
Product B
Product B
Product C
];
2. Then I have created a table with the counts of the product:
CountTable:
load
Product as Product,
Count(Product) as Count
Resident Data Group By Product;
3. In sheet, I have created a Pie Chart
4. I have added as measure the expression =Count(Product)
5. And as dimension I have added the expression =Product & ' ' & Count
6. The outcome is:
As you can see the legend displays the product names and near each product name it displays the count value for each product.
I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, please mark it as accepted solution to give further visibility to other community members.
Hello,
Thanks that looks interesting but another difference is that QlikView will display the entire legend while Qlik Sense does not.
What I did is just create a table with the values.
Thanks,
Michael