topic Re: Table box - elements have a colour? in QlikView

Table box - elements have a colour?

josephinetedesc — Fri, 31 Jul 2015 12:33:19 GMT

I have been asked to do graph, but I am not sure it what is wanted can even be done in Excel.

So I think what is wanted is something like a diary/scheduler with :

Each Acitivity has a timestamp. And to make it more useful, each Activity can be colour-coded.

I have a duration for each activity as well.

So the table looks something like this - and I think it is a good start - but given that it is a table box - am I able to add the colours to the ActivitySts as shown below? Any other ideas?

I am stumped how to start!

Re: Table box - elements have a colour?

ThornOfCrowns — Fri, 31 Jul 2015 12:40:16 GMT

A pivot table perhaps might be the starting point.

Re: Table box - elements have a colour?

datanibbler — Fri, 31 Jul 2015 12:42:26 GMT

Hi Josephine,

the tablebox is not actually a chart. It is only a tool that you can use to determine whether a keyfield is unique or something like it.

For displaying detail data out of a table, you can use it, but if you want to do anything more complex for a Dashboard, you should use a straight_table diagram instead.

It is definitely more work to add every field you need as a formula to the straight table (compared to a table_box), but then you can add background colours, even based on conditions, and the like.

So you should use that, with the time as your dimension.

HTH

Re: Table box - elements have a colour?

josephinetedesc — Fri, 31 Jul 2015 12:52:09 GMT

Thank you HTH, what is a straight_table diagram?