Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Get Expression Value from Another Object in a Sheet

Hi QV Experts! ... and Masters

I have this Segmentation table:

city segment.PNG

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:

textbox segarea.PNG

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!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Get Expression Value from Another Object in a Sheet

Turns out I need to export it first using script and read it again.

This question is solved.

Thanks

9 Replies
Not applicable

Re: Get Expression Value from Another Object in a Sheet

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))

Re: Get Expression Value from Another Object in a Sheet

Try count({<Score={'>=100<1000'}>} City)


talk is cheap, supply exceeds demand
Not applicable

Re: Get Expression Value from Another Object in a Sheet

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.

Not applicable

Re: Get Expression Value from Another Object in a Sheet

in text object write this

count(if(Score>=100,City))

sushil353
Honored Contributor II

Re: Get Expression Value from Another Object in a Sheet

is it what you are looking for.

Please find attached.

HTH

Sushil

Not applicable

Re: Get Expression Value from Another Object in a Sheet

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?

Not applicable

Re: Get Expression Value from Another Object in a Sheet

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.

Not applicable

Re: Get Expression Value from Another Object in a Sheet

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))

Not applicable

Re: Get Expression Value from Another Object in a Sheet

Turns out I need to export it first using script and read it again.

This question is solved.

Thanks

Community Browser