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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

explanation of expression

can anybody help to explain this

sum({<Date = {">=$(=vQBack)<=$(=vCFinal)"},EX.EType={'GE'},[EX.IType]={'PNC'}>}Balance)

+

sum({<Date = {">=$(=vQBack)<=$(=vCFinal)"},EX.EType={'TAllocated'},[EX.IType]={'PNC'}>}Balance) * sum({<[EType] = {'GE'}>}Data)

Labels (1)
1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III

Sum balances where

  • Date between vQBack and vCFinal (probably variables)
  • EX.EType = 'GE'
  • EX.IType = 'PNC'

And Add to

     Sum balances where

    • Date between vQBack and vCFinal (probably variables)
    • EX.EType = 'TAllocated'
    • EX.IType = 'PNC'

     Multiplied by Sum of [Data] where

    •    EType  = 'GE'
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein