YTD,This Month, This Week, Yesterday

[#1]

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]

Probably this might help you

Qlikview Scripting Tips Part 2: Two ways to create a master calendar » Quick – Qlear – Qool

[manideep78 · Accepted solution]

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.