topic Re: adding text and formula in text object in QlikView

adding text and formula in text object

marksmunich — Fri, 14 Jun 2013 11:41:19 GMT

i want to add text and 2 formulas which display the calcualted value in 2 rows in a text object

for ex: no of cities: 3456

no of states: 345

back bround in the text object will be like = count(cities)

but how to make it work for both text and 2 formulas in the same text object

T&R

Mark

marksmunich — Fri, 14 Jun 2013 11:44:50 GMT

found answer.

sujeetsingh — Fri, 14 Jun 2013 11:45:44 GMT

=sum(Fact1) & Sum(Fact2) &'Text Message '

try this

Fri, 14 Jun 2013 11:46:25 GMT

=count(cities) & chr(10) & count(states)

marksmunich — Fri, 14 Jun 2013 11:48:28 GMT

for one expression its working, how can i calculate for 2 expressions in sam text object

Fri, 14 Jun 2013 11:52:00 GMT

try this

='Number of cities = ' & count(cities) & chr(10) & 'Number of states= ' & count(states)