topic Re: Text format - expression in chart in QlikView

Text format - expression in chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart with 2 calculated expressions in the same cell by using chr(10)

sum(Price)
&chr(10)&
sum(Units)/sum(TotalUnits)

The cell looks :

I want to change the format of the first expression to be bigger.(500) i cant use the text format because the all cell text is changing

any why to do it?

Chanty4u — Tue, 29 Nov 2016 12:09:37 GMT

for two metrcis same size means you need to go font tab

orelse u need to create two seperate text objects and incorporate into single

HTH

sunny_talwar — Tue, 29 Nov 2016 12:29:23 GMT

You want the font size to be bigger or can you just make it bold?

Tue, 29 Nov 2016 12:36:54 GMT

Thank you. i need it bold and text size bigger

sunny_talwar — Tue, 29 Nov 2016 12:38:56 GMT

I think text size might be an issue and you may have to look into a macro to do this

Tue, 29 Nov 2016 13:12:09 GMT

O.K.

So how can i use it in a chart with dimmention of 10 or more values?

I want the first row of the total to be bold....

Thank you!

sunny_talwar — Tue, 29 Nov 2016 13:20:27 GMT

Something along these lines

Tue, 29 Nov 2016 13:37:07 GMT

Thank you Sunny.

This looks good... but,

1.how can i use it if the list of products is dynamic and i don't know all the values in it?

2. can it be presented in a straight table chart and not pivot table?

Thank you