Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to know how to create the following chart which is introduced in Pie chart | Qlik Sense on Windows Help . Could you please give me the details of chart function which used for calculating radius?
Sales by product sub group in a pie chart with radius measure containing a comparison of sales from the previous year
To show the following sales of 2023/3/2 in a Pie Chart with a radiu measure containing comparison of sales from 2023/2/2:
Load * inline
[
date, product, sales
2023/3/2, productA, 100
2023/3/2, productB, 120
2023/3/2, productC, 110
2023/3/2, productD, 50
2023/3/2, productE, 70
2023/2/2, productA, 130
2023/2/2, productB, 180
2023/2/2, productC, 100
2023/2/2, productD, 50
2023/2/2, productE, 80
];
Thanks
It perfectly worked in the actual data of my environment! Thank you so much for prompt support.
Based on your data, I have created this chart:
Dimension: product
Measure for Angle: Sum(sales)
Measure for Radius: Sum({<date={'2023/3/2'}>}sales) - Sum({<date={'2023/2/2'}>}sales)
or you could use dynamic like:
Sum({<date={'$(=Date(Max(date)))'}>}sales) - Sum({<date={'$(=AddMonths(Date(Max(date)),-1))'}>}sales)
The other trick is that you must select Donut under Presentation to get the radius
It perfectly worked in the actual data of my environment! Thank you so much for prompt support.