10 Replies Latest reply: Apr 24, 2014 4:31 AM by Marco Wedel RSS

    Sorting of Period

      Hi all,

       

      I am facing problem while sorting the Period.

       

      For Example, I have period field as AUG 11 AUG 12 AUG 13 DEC 11 DEC 12 DEC 13 etc for all the month.

       

      While bringing it in qlikview , i am not able to sort it.

       

      I need a following sorted in qlikview , if i build any report in qlikview .

      JAN 11 FEB 11 MAR 11 APR 11 MAY 11 JUN 11 JUL 11 AUG 11 SEP 11 OCT 11 NOV 11 DEC 11

      JAN 12 FEB 12 MAR 12 APR 12 MAY 12 JUN 12 JUL 12 AUG 12 SEP 12 OCT 12 NOV 12 DEC 12

      JAN 13 FEB 13 MAR 13 APR 13 MAY 13 JUN 13 JUL 13 AUG 13 SEP 13 OCT 13 NOV 13 DEC 13.

       

      Kindly do the needful

       

      Regards,

      Sivasu