Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Probably this might help you
Qlikview Scripting Tips Part 2: Two ways to create a master calendar » Quick – Qlear – Qool
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.