3 Replies Latest reply: Feb 17, 2016 12:59 AM by balraj ahlawat RSS

    Help with creating a dropdown in Qlik

    Scott Posey

      Hey everyone. I'm very new to QlikSense and I'm trying to figure out how to transfer an important file we use in Excel to something that would tell a compelling story in Qlik. The document is basically made to document resource management and our over/under threshold. Looking at the screenshots below, I'm trying to make a chart that will allow me to see results based off of the month. I'm hoping I'm just over analyzing and there is an easier way to format this so Qlik will handle it better.

       

      Screenshot 1 - This is the current format of the report. The months are the columns and the projects are on the left. I need to figure out how to see project numbers by month in a graph.

       

      Capture0.PNG

       

      Screenshot 2 - This is my trying to format the data differently to get different results - still having issues because the columns really aren't all inclusive.

       

      Capture.PNG

      Apologies if this is all over the place - been trying to figure out a way to do this and running blank besides scrapping the current format and making something else completely. Any help would be appreciated. Thank you.