Text function

[robert_mika]

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

Like

5000(1)

Where the number in brackets is COUNT.

[jerem1234]

do you want something like:

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

this will give something like:

5000(1)

Hope this helps!

[its_anandrjs]

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

5000(1)

[Anonymous]

hi,

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

Something like this:

RangeSum(Above(count,1,1))

[jerem1234]

Here is an example:

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

And a dashboard attached.

Hope this helps

[Anonymous]

Try with the Dual function:

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

,

Sum(Sales))

[Jason_Michaelides]

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