Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

ValueList : no results in expression

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

Tags (2)
Community Browser