Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

praveenavelagap
Contributor III

set anaylsis with above and below functions

Need help in set analysis from

set anal.PNG

this is working fine with out any filters applied, when I apply filters,these will not get calculated.

so, I want to make set analysis irrespective of selections but I could not suceed with below:

Capture.PNG

i I guess sum is not the function to be used here I suppose.

where $(linPNLActualBalance_CY_YTD) is

Capture.PNG