Discussion board where members can get started with Qlik Sense.
I need to calculate number of days and buckets as shown bellow with respect to following to dates:
Thanks & Regards,
You can try something like this:
Interval(Date1-Date2,'d') < 0 , 'Advanced',
IF ( Interval(Date1-Date2,'d') <= 30 , '0-30',
IF ( Interval(Date1-Date2,'d') <= 45 , '31-45',
'>45'))) as [buckets group],
Share your sample data with excel/text format. tks
Have you seen here:
Dynamic Time Intervals Using Calculated Dimension In QlikView - QlikView Blog, QlikView Videos and T...