8 Replies Latest reply: Jun 10, 2014 2:30 PM by Venkata Gogineni RSS

    NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

    Sudhanshu Shrivas

      I have excel file in format

       

      APR-2013japanindiafrance
      reported cases100910045677834000
      cases not filed54524234213424234
      total prison34452343332344

       

      likewise I have data for other months too for a particular year

      now I need to show this data in qlikview with respect to country and month_year

       

      I have used crosstable here

      crosstable(country,data)

       

      and it gives me data with respect to country,
      now how I can get month_year

      help me to get the month here