1 Reply Latest reply: Apr 21, 2015 4:11 AM by Gysbert Wassenaar RSS

    Bar Chart X Axis - Qliksense

      Hi All,

       

      I have an issue with headings that I want to appear on an X axis on the bar graphs in Qliksense.

       

      A small sample of my dataset is below:

      PatientPharmacy CostMedical CostRadiology CostTherapy CostWard Cost
      1    1,079.16       1,254.55        68.72     1,888.82     18,510.45
      2         35.77          746.09 NULL        175.56      2,510.16
      3       186.78           162.61 NULL         237.94       2,496.49
      4 NULL             43.34 NULL            1.61            18.86
      5         17.88            51.21 NULL        360.14          513.21
      6         41.51            62.43 NULL          77.99          673.96
      7 NULL            75.03 NULL            2.52            28.51
      8 NULL          139.28 NULL           2.52          57.53
      9 NULL          139.28 NULL          2.52        195.50
      10    2,407.36     28,367.47      174.82    7,188.27   10,648.02

       

      My actual dataset has about 30 columns and 90,000 rows of data and is not very easy to manipulate

       

      Do you know if it is possible to have the Column headings (Pharmacy to Ward) on the x-axis and have it calculating the average cost using the values in the table?

       

      Ideally I would have about 20 bars for each cost category  and an average cost for each of those.

       

      It would look a bit like the below:

       

      example.png
      Is there an easy solution to this?

       

      Many thanks

       

      Dan