Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

YTD,This Month, This Week, Yesterday

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

1 Solution

Accepted Solutions
manideep78
Valued Contributor

Re: YTD,This Month, This Week, Yesterday

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.

2 Replies
venkatg6759
Contributor III

Re: YTD,This Month, This Week, Yesterday

manideep78
Valued Contributor

Re: YTD,This Month, This Week, Yesterday

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.

Community Browser