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

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



      I have excel data sheet in following format...


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



      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.