topic Display a cross in QlikView in QlikView

Display a cross in QlikView

datanibbler — Thu, 20 Nov 2014 13:49:24 GMT

Hi,

I have the requirement to implement in a few of my apps a "safety cross" - that is a cross, made from many boxes, each carrying the nr. of one day of the month (so that all 28+ days of the month are represented) where every "day_box" can change its colour if there has been an accident on that day.

We have something like that in one app already, but it is made from a multitude of individual textboxes as I said, which makes it near impossible to change the size of this thing ... to the effect that the screen "jumps" quite a bit when switching from any other sheet to the one with this display.

<=> Is there any way to build this other than using a lot of individual textboxes - or at least to connect them all so that I can change
the size of the whole cross more easily?

Thanks a lot!

Best regards,

DataNibbler

Re: Display a cross in QlikView

rbecher — Thu, 20 Nov 2014 13:56:18 GMT

Hi,

you could use a synthetical dimension with ValueList() or ValueLoop() or use the Calendar heatmap extension from Stefan Walther: Calendar Heatmap QlikView Extension (D3CalendarView)

- Ralf

Re: Display a cross in QlikView

datanibbler — Thu, 20 Nov 2014 15:12:43 GMT

Hi Ralf,

well, extensions for one are not an option here: I don't have admin_rights on my own laptop and there's no way I can get IT to install some extension - or anything, for that matter - on the server.

I'll try the other ones.

Thanks a lot!

Re: Display a cross in QlikView

oscar_ortiz — Thu, 20 Nov 2014 15:30:32 GMT

What about something like this Square Pie:

How to create a Square Pie Chart

created by akl

Re: Display a cross in QlikView

datanibbler — Thu, 20 Nov 2014 15:38:53 GMT

Yep, another very good idea. Only - can you think of a way I can make that into the form of a cross?

Re: Display a cross in QlikView

ThornOfCrowns — Thu, 20 Nov 2014 16:00:57 GMT

I can't think of a way to get 31 locations into a cross, using the Square Pie "logic" or not..

Re: Display a cross in QlikView

oscar_ortiz — Thu, 20 Nov 2014 16:09:57 GMT

The closest I can get is something like this, using four objects:

Re: Display a cross in QlikView

ThornOfCrowns — Thu, 20 Nov 2014 16:17:52 GMT

A tiny 'cheat' but well done! Oscar Ortiz

Re: Display a cross in QlikView

datanibbler — Thu, 20 Nov 2014 16:23:14 GMT

That looks quite close to what I need, yeah.

Would you mind telling me how you did it? Then I can judge whether this will meet my requirements.

Thank you all anyway!

Best regards,

DataNibbler

Re: Re: Display a cross in QlikView

oscar_ortiz — Thu, 20 Nov 2014 17:11:22 GMT

Sorry was in a meeting.

Have a look at the attached qvw, let me know if you have questions.

Good Luck

Oscar

Re: Display a cross in QlikView

datanibbler — Fri, 21 Nov 2014 09:47:29 GMT

Hi Oscar,m

that looks really cool! I don't quite understand it, but it looks cool. - unfortunately, I guess there's no way round using individual textboxes - for I need every "day_element" to be able to change colour and display the shift (early/late) when something happened.

Thanks a lot anyway!

Best regards,

DataNibbler

Re: Display a cross in QlikView

oscar_ortiz — Fri, 21 Nov 2014 14:07:41 GMT

The objects I'm using are Pivot Tables and you do have the flexability of changing colors. My only concern is because of the shape I had to use four pivot tables in order to accomplish this. In the original Square Pie it was a single pivot table. But you do have the flexability of changing colors depending upon your expression. I simply used a MTD flag to display different colors in my example.

Looking at the middle pivot table (values 7-24)

Three things to worry about:

Dimensions:

First dimension is the number of rows you will need. ValueLoop(3,1)

Second dimension is the number of columns you will need. ValueLoop(6,1)

Expressions: (Day Element)

The expression is a counter for the position of the square, using offsets. (Column()+6) + (6*(RowNo()-1))

Color Expressions:

Background Color. This is where you would create your custom expression for dealing with shift colors.

Text Color

If you do find something that works for you I'd like to see what you come up with.

Good luck

Oscar