Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Christmas Tree in Qlik

Coming Christmas inspired me to create a Christmas Tree in Qlik Sense.
Christmas TreeChristmas Tree

 

You can have one like that in any of your applications.

The recipe is pretty simple:

  1. Create a New app.
  2. Add the following code as Load script:
SET xSize=51; //Play with the value to get required tree density
 For i.Y=1 to $(xSize);
    For i.X=1+$(i.Y) to $(xSize)-$(i.Y);
      Tree:
      LOAD 1 AS Value,
             $(i.Y) AS Y,
             $(i.X) AS X,
      RowNo() AS RowId
      AutoGenerate (1);
    Next i.X
Next i.Y

[Scroll]:  
LOAD * Inline [
Scroll
1
2
];
  1. Reload data and go to Analyze section
  2. Add a Scatter Plot chart
  • Set Dimension is RowId
  • Set First Measure Sum(X)
  • Set Second Measure Sum(Y)
  • Set Third Measure Sum(Value)*Rand()
  • Use the following expression to get  Colouring
IF(X=Median(TOTAL X) and Y=Max(TOTAL Y), '#ffd900', 
IF(Column(3)>0.9,lightred(),green(200)))

5. Add an Animator extension from the Qlik Dashboard bundle (from Sep 2020) to make it flickering.

Use Scroll as Dimension.

Press Play button and enjoy!

Merry Christmas and Happy New Year

Originally posted here

Labels (1)
1 Solution

Accepted Solutions
David_Fergen
Digital Support
Digital Support

Hi Sergey_Makushynski,

That's very awesome and great to show the holiday spirit! Hope everyone had Happy Holidays and a great New Year!

Thanks,

David

View solution in original post

2 Replies
David_Fergen
Digital Support
Digital Support

Hi Sergey_Makushynski,

That's very awesome and great to show the holiday spirit! Hope everyone had Happy Holidays and a great New Year!

Thanks,

David

View solution in original post

Anonymous
Not applicable
Author

Thanks David 🙂

Have a great New Year!