0 Replies Latest reply: Jul 27, 2016 9:09 AM by Garrett Muzikowski RSS

    How to combine multiple dimensions into one line chart?

    Garrett Muzikowski

      Hello,

       

      I am working with spending patterns over time, and have different files for each year (2012, 2013, 2014, 2015). I have saved each of these files as csv's: "Big data all of 2012" "Big data all of 2013" "Big data all of 2014" and "Big data all of 2015" as the files are too large to open in excel. I made a line chart originally combining years 2013 and 2014, with the dimension "signeddate" with no problems...However, when I downloaded 2012 and 2015 into Qlik, these dimensions saved as "Big data all of 2012.signeddate" and "Big data all of 2015.signeddate" respectively. Is there anyway where I can get these all into one line chart, even though the dimensions are labeled differently? The measures are also measured differently "dollarsobligated" vs ""Big data all of 2012.dollarsobligated"

       

      Thanks in advance for your help.