topic Re: Switch YTD to 30 Day Button click in QlikView

Switch YTD to 30 Day Button click

Wed, 18 Feb 2015 15:00:16 GMT

Is there a way that it's possible to create a button where I can just switch from YTD data to recent 30 days.

Re: Switch YTD to 30 Day Button click

Anonymous — Wed, 18 Feb 2015 18:40:42 GMT

The answer is yes. You didn't ask how, but just in case a simple example is attached.

Re: Switch YTD to 30 Day Button click

Wed, 18 Feb 2015 18:48:33 GMT

In a way I want the button to be able to change the where clause in the following sql

SELECT DATENAME(month,CREATED) as [Month],

DATEPART(Year,Created) as [Year],

COUNT(ID) as [NumberOfTickets]

from

where

CREATED BETWEEN DATEADD(yy, DATEDIFF(yy,0,'2014-12-31'),0) AND '2014-12-31' -- this can be used as year to date

group by DATENAME(month,CREATED),

DATEPART(Year,Created),

DATEPART(month,CREATED)

order by

DATEPART(Year,Created),

DATEPART(month,CREATED)

or maybe for every button it loads a different sql statement.

Re: Switch YTD to 30 Day Button click

Anonymous — Wed, 18 Feb 2015 18:59:30 GMT

The answer is still yes. Can be conditional load:

IF VAR='YTD'

ELSE

ENDIF

But this is not the right way to use QlikView. Normally you load all relevant data, and use selections/conditions/whatever on the front end, rather than reload different data every time.

Re: Switch YTD to 30 Day Button click

Wed, 18 Feb 2015 19:01:25 GMT

Thanks for your help!