1 Reply Latest reply: Aug 20, 2014 6:47 AM by Marcus Sommer RSS

    How to Combine labeled and blank cells into a single bar within a bar chart.

      Hi,

       

      I am new to QlikView and am trying to create a bar graph that presents the % completion of work documents.

       

      I want to display my data so that each document's percentage completion are in separate columns with the rows that have incomplete documents stacked on top of the completed to make up 100% (see below for excel mockup).

      Capture3.PNG

      However, in QlikView, I have my associations setup so that documents that haven't been completed are blank rows and my resulting graph ends up having a dash as a column. (The below graph is only for one of the documents)

      Capture4.PNG

      I want to be able to stack all of my blank rows on top of my "PMS Checklists" bar to replicate something similar to my mockup above.

       

      I know this is easily possible with some back end work with the data, but i have been asked to make weekly reports, and being able to simply reload my data (from Sharepoint and Access) without any manipulation would save a lot of time.

       

      Any help would be greatly appreciated.

       

      - Matt

       

       

       

       


        • Re: How to Combine labeled and blank cells into a single bar within a bar chart.
          Marcus Sommer

          I'm not sure about your datamodel and if I understand the question right but I think you need two expressions like these:

           

          First:

          count({< State = {'Complete'}>} [Document Type]) /

               count({< State = {'Complete', 'Incomplete'}>} [Document Type])

           

          Second:

          count({< State = {'Incomplete'}>} [Document Type]) /

               count({< State = {'Complete', 'Incomplete'}>} [Document Type])

           

          Maybe these expressions need an additional total and the chart needs settings by "show all values" and "suppress null-values".

           

          - Marcus