Discussion Board for collaboration related to QlikView App Development.
I have requirement to display area chart where I need to show date number in x-axis of chart.
I have to limit dimension which depends on another date i.e quater start date.
Please help me on this.
If you don't have many dates you could use this:
=match(MyDate, '1/13/2012', '1/16/2012', '2/1/2012', '2/7/2012', '2/20/2012')
or perhaps =aggr(rank(-MyDate),MyDate)
If you have more dates it's better add an extra field in the load script, or maybe use the dual function.