topic Re: YTD in the date selection but only last week in chart in QlikView

YTD in the date selection but only last week in chart

Tue, 24 Jun 2014 11:08:06 GMT

It's possible to have some charts in YTD and another one with diferent time range! It's for the report build,

Example:

I have a YTD amount spent in a chart but i need in another chart the revenue only from the last 7 days.

At the moment i've a YTD button that the user selects a date and if the button is clicked it change the selection to YTD

Thanks

Re: YTD in the date selection but only last week in chart

Gysbert_Wassenaar — Tue, 24 Jun 2014 11:13:53 GMT

Yes, that's possible. There are hundreds of discussions about YTD on this site. I'm sure you can find some using the search option at the top right of the page.

Re: YTD in the date selection but only last week in chart

Tue, 24 Jun 2014 11:54:28 GMT

Hi,

U can exclude the time granule in your expression where you don't want.

Like Sum({<TimeGranule=>}Sales).

This will exclude the time Granule Selection.

Try this. Hope it helps