topic Re: How to embed a straight table into a Combo chart in QlikView

How to embed a straight table into a Combo chart

peterderrington — Tue, 03 Mar 2020 09:47:07 GMT

I have a combo chart and over that i have created a small straight table as per picture:

Is there a way to embed the straight table into the chart so i can export the image and easily print it?

Thanks.

Re: How to embed a straight table into a Combo chart

marcus_sommer — Tue, 03 Mar 2020 12:05:55 GMT

I think it's not directly possible. Your table doesn't look very complex and therefore you may re-create the table within one or several textboxes - I mean the free text feature from the tab presentation (bottom right). For it you will need some aggr() and some logic to align - usually counting the length of the items and using it as parameter for a repeat() or similar - the content within it - maybe something in this way:

concat(aggr(Date & ' ' & YourExpression, Date), chr(10))

- Marcus

Re: How to embed a straight table into a Combo chart

peterderrington — Tue, 03 Mar 2020 14:37:23 GMT

Thanks for coming back to me.

That isn't quite working it just shows 7 lines of 0

The Expression i used was: =concat(aggr(Date&''=[Early Finish or Late],Date),Chr(10))

I was also wanting it to be able to colour code the responses, on the original table i used this expression within the text color field to produce this:

Pick(Match(Finish,'On Time','Early','Late'),Blue(),Green(),Red())

I tried to input that code into the Font, Base Color, Calculated field but it just said bad field for Finish.

Any ideas?

Re: How to embed a straight table into a Combo chart

marcus_sommer — Tue, 03 Mar 2020 14:52:54 GMT

The syntax isn't right - it should be rather:

= concat(aggr(Date & ' ' & [Early Finish or Late],Date),Chr(10))

and it might be helpful to play with the logic within a dummy-textbox instead of the chart (easier access to the properties and less calculations). It might be also needed that you adds some more logic - further dimensions in which context the calculation should happens, any needed set analysis and so on and of course using the right fields/expressions.

Any coloring here won't be possible - but ou may use upper/lower() and/or further ascii-chars to highlight respectively differ more between the results.

- Marcus

Re: How to embed a straight table into a Combo chart

peterderrington — Tue, 03 Mar 2020 15:29:08 GMT

So that has worked beautifully with one small complication.

Its decided to put the 01/03/20 date at the top of the list so it looks like this:

Any ideas why?

Its a shame about the lack of colouring but i'm sure we can live with it.

Re: How to embed a straight table into a Combo chart

marcus_sommer — Tue, 03 Mar 2020 15:36:27 GMT

By concat you could add a third parameter to order the results, like:

concat(aggr(Date & ' ' & [Early Finish or Late],Date),Chr(10), Date)

Important is that the parameter is numeric - means here it must be a real date.

- Marcus

Re: How to embed a straight table into a Combo chart

peterderrington — Tue, 03 Mar 2020 15:53:59 GMT

Thank you, this is great and has also helped me with a couple of other elements too using the same idea in the syntax.

Its a shame the colour picking on the expression doesn't work but you can't have everything.

Thank you!