topic Re: What does this underscore mean here? in QlikView

What does this underscore mean here?

Anonymous — Thu, 13 Jun 2013 06:10:02 GMT

please find the below expression and let me know what does this expression mean??

Expression:

Avg(
Aggr(
If(
// First Month
Sum ($(eCycleGroupLevel_MasterCycle_Field)_Sum_End_Inv - [$(eCycleGroupLevel_MasterCycle_Field)_Next Month 1 Sales] )<=0,
(
Sum ($(eCycleGroupLevel_MasterCycle_Field)_Sum_End_Inv) // Remaining Inventory
/
Sum ([$(eCycleGroupLevel_MasterCycle_Field)_Next Month 1 Sales])
)
*
Sum ([$(eCycleGroupLevel_MasterCycle_Field)_Next Month 1 Days]) * 7 , // First Months Days

$(eCycleGroupLevel_MasterCycle2) , ACCT_MO_NM_ABBR

// Aggregation

)

Also please let me know the meaning of underscore here :

$(eCycleGroupLevel_MasterCycle_Field)_Sum_End_Inv

Re: What does this underscore mean here?

sujeetsingh — Thu, 13 Jun 2013 06:12:33 GMT

underscore is the name of the field Eg.-ACCT_MO_NM_ABBR here it is used in mane .

Re: What does this underscore mean here?

Thu, 13 Jun 2013 06:32:04 GMT

in your code

[$(eCycleGroupLevel_MasterCycle_Field)_Next Month 1 Sales] is treated as a field,

so i think you should not focused on Underscore, because

you must write the below code in [ ] bracket. like

[$(eCycleGroupLevel_MasterCycle_Field)_Sum_End_Inv] this is also a field.