topic Requirement on Set analysis in QlikView

Requirement on Set analysis

Wed, 25 Nov 2020 16:16:04 GMT

i need to display data like:

1)Last 5 years data

2)last 5 months data

3)last 5weeks data

4)last 5 days data

5)Last 5 hours

my date fields is: OrderDate

Thanks

Re: Requirement on Set analysis

sunny_talwar — Fri, 03 Jun 2016 19:25:52 GMT

May be like this:

1) {<OrderDate = {"$(='>=' & Date(AddYears(Max(OrderDate), -5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

2) {<OrderDate = {"$(='>=' & Date(AddMonths(Max(OrderDate), -5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

3) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 35), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

4) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

5) Is OrderDate a timestamp? If not, then I am not sure how this can be calculated

Re: Requirement on Set analysis

Fri, 03 Jun 2016 19:56:08 GMT

yes it is a time stamp based

Re: Requirement on Set analysis

sunny_talwar — Fri, 03 Jun 2016 19:59:52 GMT

Then try this:

1) {<OrderDate = {"$(='>=' & Date(DayStart(AddYears(Max(OrderDate), -5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

2) {<OrderDate = {"$(='>=' & Date(DayStart(AddMonths(Max(OrderDate), -5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

3) {<OrderDate = {"$(='>=' & Date(DayStart(Max(OrderDate) - 35)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

4) {<OrderDate = {"$(='>=' & Date(DayStart(Max(OrderDate) - 5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

5) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 5/24), 'DateFieldFormatHere') & '<=' &Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}