topic Re: YTD + LYTD button - error in QlikView

YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 06:22:10 GMT

Hello,

I have created a textbox button with the following statement:

='(>=' &YearStart(Today())& ' and <='& date(Today()) &')

(>=' &YearStart(Today(),-1)& ' and <='& AddMonths(Today(),-12) &')'

Result text-string:

(>=01.01.2013<=22.08.2013) or (>=01.01.2012<=22.08.2012)

This result is a parameter in a text box --> action --> selection in field

So far so good.

Problem: Only the first part of the search criteria is used in my app.

The filter is only working for the period 01.01.2013 – 22.08.2013.

Any ideas why this solution does not work?

If I change the input to (>=01.01.2012<=22.08.2012) or (>=01.01.2013<=22.08.2013) then
the search is only possible for the period 2012.

Thank you very much

Robert

Re: YTD + LYTD button - error

tresB — Mon, 26 Aug 2013 06:34:43 GMT

try removing the braces, like

>=01.01.2012<=22.08.2012 or >=01.01.2013<=22.08.2013

Re: YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 06:58:13 GMT

Hi,

without braces no search is possible.

Even if I type in this directly into a listbox.

I think the braces are necessary.

Re: YTD + LYTD button - error

tresB — Mon, 26 Aug 2013 07:05:30 GMT

try to put this string directly in the search string (without '='). it should work if the date format is similar.

>=01.01.2012<=22.08.2012 or >=01.01.2013<=22.08.2013

Re: YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 07:30:15 GMT

OK - if I put this string in a listbox then it works.

But how can I achieve now a button to to this? Because here I need a '='.

I have tried now to create my search string in the script.

Result is the same as I do it in the text box under action. Only year 2013 selection is available

Re: YTD + LYTD button - error

tresB — Mon, 26 Aug 2013 07:37:53 GMT

try:

='>=' &YearStart(Today())& '<='& date(Today()) &

'or' &

'>=' &YearStart(Today(),-1)& '<='& AddMonths(Today(),-12)

Re: YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 08:01:00 GMT

Unfortunatly still only 2013 period selected.

2012 will be ignored..

Re: YTD + LYTD button - error

tresB — Mon, 26 Aug 2013 08:08:46 GMT

Could you please share the sample app?

Re: Re: YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 08:23:53 GMT

See attached. Thank you so far.

Re: YTD + LYTD button - error

Gysbert_Wassenaar — Mon, 26 Aug 2013 08:27:49 GMT

Try:

='(>=' &YearStart(Today())& ' and <='& date(Today()) & '| >=' &YearStart(Today(),-1)& ' and <='& AddMonths(Today(),-12) &')'

Re: YTD + LYTD button - error

robbybalboa — Mon, 26 Aug 2013 08:33:03 GMT

Gratulation.

This is the solution - not to use the braces in the middle of the statement.

Thank you all for your support.

Robert

Re: Re: YTD + LYTD button - error

tresB — Mon, 26 Aug 2013 08:42:00 GMT

PFA, it's working fine.

Edit: Well, you have got the solution already, anyway, an alternative is always good.