Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Area chart X-axis need to be as date number

I have requirement to display area chart where I need to show date number in x-axis of chart.

Date(MM/DD/YYYY)Expected chart x-axis
1/13/20121
1/16/20122
2/1/20123
2/7/20124
2/20/20125

I have to limit dimension which depends on another date i.e quater start date.

Please help me on this.

Thanks

1 Reply
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand