topic Data selection based on another selection in QlikView

Data selection based on another selection

Thu, 14 Jul 2016 14:34:58 GMT

Hi All,

Based on the data below, I am trying to achieve as a chart expression the following...

Sum of stock for the minimum week number in 2016 i.e. 40 (from week 11)

& am trying things like this...

=SUM (if(Year=2016 and Week= (Min(if(Year=2016,Week))) ,Stock))

=SUM ({$<Week = {$(min(total Week))} ,Year ={2016}>} Stock)

but it is not happy with any of these logics... any ideas please ?

Thanks in advance

Bob

sunny_talwar — Thu, 14 Jul 2016 14:39:09 GMT

May be try this:

Sum({<Week = {"$(=Min({<Year = {$(=Max(Year))}>}Week))"}>}Stock)

Thu, 14 Jul 2016 14:40:48 GMT

Thank you so much - works perfectly !!!!!!!!!!!!!!!!!!!!