Discussion Board for collaboration related to Creating Analytics for QlikView.
i have a formula with an interval statement which got a formatting 'dd:hh:mm'. Everything works fine. But i need a description of Days in my chart.
At the moment, for example my chart looks like '22:20:03' but now i want to have it like this way '22 Days 20 hours 03 Minutes'.
Is that possible?
Floor(MyInterval) & ' Days' & Hour(MyInterval) & ' Hours' & Minute(MyInterval) & ' Minutes'
When I write ' Days' behind the first part of the formula, in my chart there are no values. But for example '%' works...