Expression

[smilingjohn]

Hi All,

I have a issue with my set analysis expression below

rangeSum(Before(TOTAL Count({<Year*={">2015"},Department={'Cosmatics','Finance','IT','Sales'}>}Key)+ Sum({1<Year*={">2015"}>}0),0, ColumnNo(TOTAL)))

Here the results in my pivot table displays the data after 2015 which is correct . But when i select year 2019 from list box " I expect the pivot table to display the data for the 2019 . but it is showing the
data after 2015 .

DO we need to make any modification to the expression.

I am showing the data in weeks.

Thanks In Advance

[Brett_Bleess]

John, have a look at the following Design Blog post, hopefully that may help you on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

If you want to search around in this area further, here is the base URL:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Sorry I am not more help, Set Analysis tends to make my brain hurt, have never been able to get it to click for me, so I am not much help otherwise.  From what I can see though, I believe things are working as expected, the expression is overriding the selection etc., which it should given the expression as far as I know.  Someone else may chime in at this point now that I have posted to further explain.  I think instead of the actual Year, you might need to change that to the list box year field in order to have it do what you want, but if nothing is selected, not sure that is going to do what you want then...

Regards,
Brett