Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text object expression.

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

1 Solution

Accepted Solutions
its_anandrjs

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

View solution in original post

8 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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

its_anandrjs

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

Or

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

Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

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

jagan
Luminary Alumni
Luminary Alumni

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.

its_anandrjs

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

Not applicable
Author

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