topic Re: Text function in QlikView

Text function

robert_mika — Fri, 13 Jun 2014 14:04:14 GMT

Does Qlikview have fuction simialr to Exce TEXT().

I need to Count a number for chart but being the second part and not taking this into calculations

5000(1)

Where the number in brackets is COUNT.

jerem1234 — Fri, 13 Jun 2014 14:08:55 GMT

do you want something like:

=sum(FIELD) & '(' & count(FIELD) & ')'

this will give something like:

5000(1)

Hope this helps!

its_anandrjs — Fri, 13 Jun 2014 14:14:57 GMT

Can you explain with an example and what is mean for the word in brackets, elaborate more.

5000(1)

Anonymous — Fri, 13 Jun 2014 14:23:02 GMT

hi,

Try with the Range sum and Above function to get the count:

Something like this:

RangeSum(Above(count,1,1))

jerem1234 — Fri, 13 Jun 2014 14:25:34 GMT

Here is an example:

=sum(Sales) & '(' & count(Person) & ')'

And a dashboard attached.

Hope this helps

Anonymous — Fri, 13 Jun 2014 14:38:35 GMT

Try with the Dual function:

=dual(Sum(Sales) & '(' & count(Person) & ')')

Sum(Sales))

Jason_Michaelides — Fri, 13 Jun 2014 14:46:44 GMT

See my response to your other question - http://community.qlik.com/thread/121844