This content has been marked as final. Show 4 replies
I think I remember that QlikView can formatting the date when we insert it from an excel file.
I have my date DD/MM/YYYY and I want to sort my data by day, month , year and week.
I know that for example if I want to sort by month I can write "date(monthstart(DATE),'MM/YYYY')"
But is it possible to count weeks (from 1 to 52) ?
Please help me ...