All data upto selected date

Anonymous — Mon, 28 Feb 2011 14:37:28 GMT

Dear specialists,

I have a master calender which works like it should when I want to make a selection.

But i want my Qlikview charts to show all the information up to the selected date.

So if I select 1-12-2009 it should also get all data before that date

So what I want to use the calander to select the maximal date in the selection.

All data upto selected date

Mon, 28 Feb 2011 15:07:58 GMT

Do you select the Month, Day, and Year separately? If so maybe you need this set analysis:

{$<Month={"<=$(=only(Month))"}, Day={<=$(=only(Day))}, Year={<=$(=only(Year))} >}

If you select the date with a calendar object maybe you only need:

{$< Date={"<=$(=(date(vSelectedDate, 'YYYY-MM-DD 00:00:00')))"}>}

The YYYY-MM-DD format can be whatever you need. The vSelectedDate is a variable holding the calendar objects selection.

topic All data upto selected date in QlikView

All data upto selected date

All data upto selected date