4 Replies Latest reply: Sep 7, 2017 9:10 AM by Vineeth Pujari RSS

    How can I make this data usable in Qlik to create a data visualization?

    Debashish Banerjee

      Hello all,

       

      I am currently working on a Qlik Sense visualization regarding health care spending and I am planning to use this data sheet. However, given the format that it is in, I'm not sure how to make working dimensions and measures within Qlik Sense to display this data. Each column is not an aggregation of everything combined and I'd like to show these trends over times in their respective years. How can I go about solving this? Would I have to go into the data load editor or edit the sheet in Excel? I'm attaching a screenshot for your convenience, thanks again in advance and I look forward to hearing from you all!

       

      Sincerely,

      Debashish