topic Re: Get Expression Value from Another Object in a Sheet in QlikView

Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 09:42:37 GMT

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!

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 09:55:27 GMT

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

Gysbert_Wassenaar — Thu, 23 May 2013 09:57:05 GMT

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

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 10:00:48 GMT

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.

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 10:02:55 GMT

in text object write this

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

Re: Get Expression Value from Another Object in a Sheet

sushil353 — Thu, 23 May 2013 10:03:59 GMT

is it what you are looking for.

Please find attached.

HTH

Sushil

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 10:22:56 GMT

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?

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 10:25:13 GMT

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.

Re: Get Expression Value from Another Object in a Sheet

Thu, 23 May 2013 12:11:57 GMT

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

Re: Get Expression Value from Another Object in a Sheet

Mon, 27 May 2013 07:09:43 GMT

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

This question is solved.

Thanks