topic Re: How to calculate an object's size ? in QlikView

How to calculate an object's size ?

Mon, 14 Dec 2015 07:55:31 GMT

Hi everyone !

Is there a way to define a text object’s size with an expression ?

Here is my example :

I have two text objects :

- “Number of boys : 153”

- “Number of girls : 170”

153 and 170 are the result of an expression.

I would like the girl’s text object to be bigger than the boy’s one when there are more girls than boys (the size of the text object depends on the result).

Is that possible ?

Thanks,

Best regards,

Sarah

Re: How to calculate an object's size ?

marcus_sommer — Mon, 14 Dec 2015 09:59:36 GMT

This isn't possible with a single textbox - you will need several textboxes which are laying over eachother and where the visibility is controlled with variables. An alternatively could be an extension like: QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension).

- Marcus

Re: How to calculate an object's size ?

r_wroblewski — Mon, 14 Dec 2015 09:59:50 GMT

Hi Sarah,

I think you need to create two text objects and use conditional show to create something like that.

You can't use an expression for the size of an object as far as I know.

Best regards,

Ronny

Re: How to calculate an object's size ?

Mon, 14 Dec 2015 10:20:57 GMT

Thanks, I'll try this

Re: How to calculate an object's size ?

Mon, 14 Dec 2015 10:21:13 GMT

Thank you