topic Re: YTD,This Month, This Week, Yesterday in QlikView

YTD,This Month, This Week, Yesterday

Wed, 18 Jun 2014 19:07:17 GMT

Is there a way to create YTD, This Month, This Week, and Yesterday as option under a list box? If so how do you go about it.

David

venkatg6759 — Wed, 18 Jun 2014 19:24:33 GMT

Probably this might help you

manideep78 — Thu, 19 Jun 2014 10:34:13 GMT

Hi David,

we dont have any default option for a list box , we need to make these fields by using existing date field.

for example,

if we have OrderDate field as a key field,

then we can make YTD (Year To Date )

Year(OrderDate) as Year,

Month(OrderDate) as Month,

Day(OrderDate) as Day

in the load script.