topic Re: Multiple labels divided with a line in QlikView

Multiple labels divided with a line

Thu, 26 Feb 2015 20:33:18 GMT

I have that expression.

Is it posible to have two labels like that divided by a line?

I used label 1 & ' ' & label 2

but i'd like that line

Greetings

Re: Multiple labels divided with a line

jerem1234 — Thu, 26 Feb 2015 20:40:24 GMT

You can try to just add the line yourself by using a line/arrow object or a squished textbox. There is no real option to add that line, without manually placing a line on top of the table.

Hope this helps!

Re: Multiple labels divided with a line

Thu, 26 Feb 2015 20:45:42 GMT

Mmm thank you but i'm not sure if this is gonna help because i'll send this object with a .net macro by email.

greetings!

Re: Multiple labels divided with a line

Anonymous — Thu, 26 Feb 2015 20:45:45 GMT

there is no perfect easy way to do this.

did you try label 1 & '------------- ' & label 2?

or this - you could have the label1's in a separate table with no data in it and make the label2's header size big enough and align them to the bottom and overlay the label1's table on top of it with a higher layer number - this is obviously not going to work with your email macro!

Re: Multiple labels divided with a line

Anonymous — Thu, 26 Feb 2015 20:48:51 GMT

Or this (not a great line though, but at liast it doesn't stay if you minimize the table):

='Label 1' &chr(10)& '----------------' &chr(10)& 'Label 2'

If you don't allow to minimize/maximize/move the table, you better use the suggestion from jerem1234

Re: Multiple labels divided with a line

Thu, 26 Feb 2015 20:54:48 GMT

Thank you both!

Another question

Do you know how to put all that labels in green? only that labels, not all the table nor the dimensions

Greetings

Re: Multiple labels divided with a line

Anonymous — Thu, 26 Feb 2015 20:59:57 GMT

if you right click on the label (i think you mean the headers in a table) and select custom format cell, additional formatting can be done.