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
Where the number in brackets is COUNT.
do you want something like:
=sum(FIELD) & '(' & count(FIELD) & ')'
this will give something like:
Hope this helps!
Here is an example:
=sum(Sales) & '(' & count(Person) & ')'
And a dashboard attached.
Hope this helps
Can you explain with an example and what is mean for the word in brackets, elaborate more.
Try with the Range sum and Above function to get the count:
Something like this:
Try with the Dual function:
=dual(Sum(Sales) & '(' & count(Person) & ')')
See my response to your other question - http://community.qlik.com/thread/121844
Retrieving data ...