topic Re: YTD until selected day in QlikView

YTD until selected day

Wed, 11 Jun 2014 14:02:16 GMT

Hi guys,

I'am trying to display the information until a user selected date, the problem is

Example:

The user wants the YTD until 5 June, so he selects in months the JAN, FEB, MAR , ... JUN, in the weeks 1,2,3,4..,23 but now the problem how i select all the day's until 5 June?

Re: YTD until selected day

alexandros17 — Wed, 11 Jun 2014 14:09:59 GMT

If you need a sum of sales for example, then write

Sum({$ <myDate={'<=$(=GetFieldSelections(myDate))'}>} sales)

let me know

Re: YTD until selected day

Wed, 11 Jun 2014 15:45:11 GMT

no is not a particular function but all the data displayed, like the drill does

Re: YTD until selected day

ashfaq_haseeb — Wed, 11 Jun 2014 16:31:12 GMT

Hi,

Below post might help you.

YTQ, QTD, MTD and WTD

Regards

ASHFAQ

Re: YTD until selected day

Fri, 13 Jun 2014 08:46:40 GMT

The solution was creating a button and set action "select in field": "my DateField" and the search string: = '>=' & vStartDate & '<=' & vEndDate, where my vStartDate it's the current year and vEndDate it's the selected date