Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV Experts! ... and Masters
I have this Segmentation table:
I got the City from data loading process, and I add the Segment Area column using expression in the table using some calculation.
=If(Score >= 100, 9, If(Score >= 1000, 8, ...
Btw, I hid the Score column; which is also get it from data loading process.
Now I create in the same sheet, a text box object to count "How many cities currently in the Segment Area?" as you can see below:
It doesn't work the way I want.
How can I get the count of "How many cities currently in the Segment Area?" and put it in the text box?
Please help. Thanks in advance!
Turns out I need to export it first using script and read it again.
This question is solved.
Thanks
How many cities currently in the Segment Area
IN CHART --> EXPRESSION
WRITE
expression1--
If(Score >= 100, 9, If(Score >= 1000, 8, ...
expression2--
count(IF([Segment Area]<>0,City))
Try count({<Score={'>=100<1000'}>} City)
Hi Vish!
I don't wanna put it in the chart/straight table, but I need to display the count number in the TEXT BOX.
How can I do this?
Thanks.
in text object write this
count(if(Score>=100,City))
is it what you are looking for.
Please find attached.
HTH
Sushil
Hi Gysbert!
Sorry to tell you but it doesn't seem to work.
Since the Segment Area is already calculated in the TABLE, can I use the GetObjectField() function?
How to do it?
Hi Sushil!
I got the City from data loading process, and I add the Segment Area column using expression in the table using some calculation.
=If(Score >= 100, 9, If(Score >= 1000, 8, ...
Btw, I hid the Score column; which is also get it from data loading process.
I guess you've missed that I get the segment area using expression.
Thanks.
hope this helps you
firstly write this code in script
If(Score >= 100, 9, If(Score >= 1000, 8, ...) as [Segment area]
then in text box write this below code
count(Total <[Segment area]>City))
Turns out I need to export it first using script and read it again.
This question is solved.
Thanks