Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Question

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 :

Month not selected.PNG

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

Month selected.PNG

1 Reply
Kushal_Chawda

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)