10 Replies Latest reply: Jan 7, 2015 6:50 PM by Petter Skjolden RSS

    How to use different filters on X and Y in a scatter plot?

    Anthony williams

      I have my data organised like shown below. I have previously used Excel for this type of evaluation, but am looking at Qlik Sense for another way of evaluating data. I am also looking at QlikView. The table is obviously significantly larger than shown below with a couple of hundred parameters. In Excel I used a slicer and pivot table to select the data and a dynamic scatter chart to display the selected data.

       

      Index

      Country

      Parameter

      Amount ($)

      1

      Australia

      Revenue

      3656

      2

      Australia

      Profit

      2365

      3

      Australia

      Maintenance

      500

      4

      Australia

      Miscellaneous Expenses

      632

      5

      United States

      Revenue

      6965

      6

      United States

      Profit

      3326

       

      X data could be extracted by: Value in Amount column (Filtered by Parameter)

      Y data could be extracted by: Value in Amount column (Filtered by different Parameter to X)

      Country could be used as a global filter for both axes.

       

      Is it possible to prepare a Scatter plot for data in this format? 

       

      Thanks in advance for your help!