topic Re: Text object expression. in QlikView

Text object expression.

Sat, 22 Nov 2014 02:06:29 GMT

Hi,

I am using the following expression (TEXT OBJECT):

=NUM(((sum(T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

(T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

I want to make it fixed value so it should not get updated even I make any field selections in the application.

Thanks in advance

Re: Text object expression.

Anonymous — Sat, 22 Nov 2014 02:45:31 GMT

I would suggest a otherway , create a straigt table with the same expression and dummy dminesion(like =1 and in the presentation tab of properties check hide column radio button) .

then ditach the object.

it will not reflct for any selections.

I do not see detach option for text object.

BR,

Chinna

Re: Text object expression.

Sat, 22 Nov 2014 04:14:18 GMT

there are no way to solve this in the text object ??

Re: Text object expression.

its_anandrjs — Sat, 22 Nov 2014 05:08:54 GMT

Hi,

You can try SET expression in the expression like

=NUM(((sum({1} T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

(T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

You can create any variable and then try to use it here

vExprVar =

=NUM(((sum({1} T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG(AGGR(SUM

(T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

and use it in text object like

=$(vExprVar)

Hope this helps

Regards

Anand

Re: Text object expression.

Sat, 22 Nov 2014 06:08:26 GMT

it doesn't work.. anyway. thanks Chouhan.

Re: Text object expression.

Anonymous — Sat, 22 Nov 2014 06:35:34 GMT

Hi,

Try to use set analysis with 1 so that it can use all the values . No matter what selection you have made.

Re: Text object expression.

jagan — Sat, 22 Nov 2014 06:48:27 GMT

Hi,

Try like this, you need to give {1} in all aggregation functions

=NUM(((sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)/AVG({1}AGGR(SUM

({1}T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*T_NST_MAXMONTHDAYS,'###,##0')

Regards,

Jagan.

Re: Text object expression.

its_anandrjs — Sat, 22 Nov 2014 06:55:05 GMT

Try once this one with {1} as i post earlier also with both numerator and denominator values.

=NUM( ( ( Sum( {1} T_NST_CD_OUTQTY1_DAY_RW ) / T_NST_ELAPSED_DAYS )

AVG( {1} AGGR(SUM( {1} T_MERRTE_STEP_COUNT ), T_NST_DEVICE ) ) )

* T_NST_MAXMONTHDAYS,'###,##0' )

Regards

Anand

Re: Text object expression.

Sat, 22 Nov 2014 06:57:46 GMT

Hi hyunseok ,

the values are getting diffrent because in your formula

(sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/T_NST_ELAPSED_DAYS)

for T_NST_ElapsedDays you didn't use any aggregation function , while your sum(T_NST_OUT_QTY1_DAY_RW) doesn't affect with filter.

if your formula is getting you the correct value, then you can apply sum or avg in front of this and write

(sum({1 }T_NST_CD_OUTQTY1_DAY_RW)/sum({1}T_NST_ELAPSED_DAYS))

AVG({1}AGGR(SUM

({1}T_MERRTE_STEP_COUNT),T_NST_DEVICE)))*sum({1}T_NST_MAXMONTHDAYS),'###,##0')

With Regards

Harshita Gaur