Day or Date range in Set analysis Expression

Anonymous — Thu, 23 Feb 2017 13:06:00 GMT

Dear Friends

I have an expression like below:

=sum( {< NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>} sales)

I need to add a Day range to this in set analysis like from the 1st of a month to a particular date which is decided by value another column.

Example: Value in other column is 16 then it should show sales from 1st of the month to 16th. I have Day, DayMonth and Date field available as attached screenshot.

How can I use these fields in set analysis.

Regards

Chintan

Re: Day or Date range in Set analysis Expression

MK_QSL — Thu, 23 Feb 2017 13:45:43 GMT

=sum( {< Date = {">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}, NEW_AGENT_NAME={'*'},NEW_ENTITY_CODE={'CPM078361*'},BILL_TYPE={'SELL'}>} sales)

topic Re: Day or Date range in Set analysis Expression in QlikView

Day or Date range in Set analysis Expression

Re: Day or Date range in Set analysis Expression