How to use different filters on X and Y in a scatter plot?
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?
