Hello,
I am extremely new to data analytics. I am probably making this task more difficult than it actually is. What I am trying to do is separate my fields so I actually have dimensions and measures. Right now my fields look like this
FurnitureClaimsOutsideServiceArea
ApplainceClaimsOutsideServiceArea
FitnessClaimAmountsOutside ServiceArea
ElectronicsClaimAmountsOutsideServiceArea
I'd like to have each category be it's own dimension and then the measure just be claims outside of service area. What do I need to do to my dataset to have it function so when they select fitness from the filter pane the map displays data for that category only? It's an excel sheet that I loaded into Qlik and I am trying to make the dataset clean.