Set Analysis Question

Sat, 22 Apr 2017 20:38:41 GMT

Hi All,

I have a chart to calculate Average Preview Time ( MTD) with following expression:

=Sum({<PreviewedFirst={1},CallCentre-={'UNKNOWN'}, Month=, Quarter=, Week=, Day, DateNum={">=$(=Num(MonthStart(Max(DateNum))))<=$(=Max(DateNum))"},DayType={'Working Day'}>}PreviewTime)/sum(timespent). Now when there is no Month(April) selected I get :

But when I select Month (April) then I get this chart and of which is the correct one

Re: Set Analysis Question

Kushal_Chawda — Sun, 23 Apr 2017 07:27:40 GMT

may be like

=Sum({<PreviewedFirst={1},CallCentre-={'UNKNOWN'}, Month=, Quarter=, Week=, Day, DateNum={">=$(=Num(MonthStart(Max({<Month=, Quarter=, Week=, Day, DateNum=>}DateNum))))<=$(=Max({<Month=, Quarter=, Week=, Day, DateNum=>}DateNum))"},DayType={'Working Day'}>}PreviewTime)/sum(timespent)

topic Set Analysis Question in QlikView

Set Analysis Question

Re: Set Analysis Question