0 Replies Latest reply: Apr 29, 2016 4:08 AM by Charles Malec RSS

    ValueList : no results in expression

    Charles Malec

      Dear all,

       

      I have a pretty "complex" report (it is just the top part, it goes for several books, country, years ...)

      Capture.PNG

       

      The dimensions are mainly calculated to filter for example for country :

      =IF(Match(STRATEGY,'FR','BE','NL','DE'),STRATEGY)

       

      I have created a value list to have a column for Volume and MTM per year.

      =ValueList('Volume','MTM')

       

      The "Volume Hedge" is given by the following expression :

      =sum({$<CPTY={'OFFV','CCBG','XDOA','XDCO','ECNG'}>}VOLSTD/1000*IF(BS='S',-1,1))

       

      And I have tried in the "Volumes Asset" to split the results between MTM and Volume using the following formula :

      =If(ValueList('Volume','MTM')='Volume',sum({$<CPTY-={'OFFV','CCBG','XDOA','XDCO','ECNG'}>}VOLSTD/1000*IF(BS='S',-1,1)),0)

      So for my understanding it should give a different result between column volume (the VOLSTD) and MTM (0 but will be replaced by another expression)

       

      It sounds pretty logical for me but I cannot understand why it is not working (first line shouldn't be two 0, at least a value for the Volume and a 0 for the MTM.)

       

      Since I am pretty new in Qlikview it might look to experienced user as "dirty" code but I am under a lot of pressure to end this report today as it is ... (and it should look like this). I just have access to the web interface and cannot modify the "source".

       

      If you have any solution or advice please feel free to contribute.

       

      Kind Regards,

       

      Charles