I am just starting to get my feet wet with Qlik Sense and I am not a coder by trade, so please bear with me. My current table shows more columns than I want it to (see attachment for an example). The purpose of the table is to show surgical case counts by doctor for the past three years and by specific facilities from a field titled Facility Group Name. The formula used to calculate the surgical volume is shown below. The attachment shows the current facility group names and I would like to be able to have the chart only show OSF, RMH, and SAH without having to filter down on them. Thank you in advance!
I do not know all the proper terminology, but looking further into the table it appears that the dimension is called Facility Group Name and these are all locations within that dimension. Using the formula that you provided did not work. Any other suggestions? Thanks!
Please refer back to the image in the original post. I would like the Facility Group Dimension that currently contains AGSH, ARSC, CENT, OSF, RMH, SAH, and SHER to only show OSF, RMH, and SAH when I pull it in as a column within my table.