Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Chart Scripting is a very well hidden new feature in Qlik Sense August 2022. I only found it mentioned in the release notes.
- It is not mentioned in the "What's new App": https://showcase3.qlik.com/sense/app/bcca6893-a1b3-4763-8c5d-55ca7679878b/overview
- I don't get the example working from help.qlik.com https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/ChartLevelScripting/ch...
@Patric_Nordstrom : any advanced demos on this feature?
I played a little bit around, and this example is working for me.
Let P = HCNoRows(); For J = 1 to P Put #hc1.measure.2(J) = HCValue(#hc1.measure.1, P-J+1) ; Next
Still I'm not quite sure how helpful this new feature is in real world. So I would be glad about every example that shows some good use cases on this topic.
Thx,
Roland
Now the feature made it to the Qlik Design Blog with some examples for download: https://community.qlik.com/t5/Qlik-Design-Blog/Chart-Level-Scripting-Use-Cases-Samples-and-Examples/...
I guess the feature was somehow forgotten with all the AutoML hype. But I think we now have some good examples to work with this feature!
I have found interesting video on this topic. Steven Pressland explains Chart Scripting in details. See attached file.
thx!
Best video on this topic I have seen so far.
@Steven_Pressland : can you provide the .qvf you used in the video somewhere!
Thx,
Roland
Now the feature made it to the Qlik Design Blog with some examples for download: https://community.qlik.com/t5/Qlik-Design-Blog/Chart-Level-Scripting-Use-Cases-Samples-and-Examples/...
I guess the feature was somehow forgotten with all the AutoML hype. But I think we now have some good examples to work with this feature!
I tried to do the Sunflower spiral that Steven Pressland shows in the video but I get an error. Have any other tried it.
I use this script
ADD LOAD
RowNo()+1 as #hc1.dimension.1,
1 as #hc1.measure.1,
1 as #hc1.measure.2
Autogenerate(999);
let Theta = 0;
Let GoldenRatio = 1.61803398874989484;
Let GoldenAngel = 360-(360/GoldenRatio);
For i = 1 to 1000
Let Distance = Sqrt(i);
Let Theta = Theta + GoldenAngel;
Put #hc1.measure.1(i) = Distance * cos(Theta * pi() /180);
Put #hc1.measure.2(i) = Distance * sin(Theta * pi() /180);
Put #hc1.measure.1.attribute.1(i) = Mod(i, $(vColors));
next i;
And get this error