Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

What does this underscore mean here?

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

Labels (1)
2 Replies
sujeetsingh
Master III
Master III

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

Not applicable
Author

hi

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.