8 Replies Latest reply: Jan 28, 2015 3:06 AM by Akshay Rai RSS

    How to get Year and Quarter in different list box...!!


      Hi,

       

      I have excel data sheet in following format...

       

      CountryProductSub-ProductUnitsQ1'14Q2'14Q3'14Q4'14FY'2014So on...
      ABCXYZX1Y1Z1xx

       

       

      While uploading this file on qlikview the year and quarter value appearing in same listbox. I want to have two list box "Quarter" and 'Year". Please advice the format, in case data sheet need to be transformed or i can get the desire result with the same data sheet.

       

      Regards,