Filtering a pivot table to show only the "true" values
I am finding it very easy to feel stupid as a newbie to QlikView. With respect to Qlik because it is a great application, the documentation is not the most user friendly thing out there and while the forum is great, it can be frustrating to try and find the exact thing you need to accomplish something.
I would think this should be easy but I cannot find the answer.
I have created a small table to look at the number of patients, costs, and ER visits in patients with Ovarian CA. One of the things I have created in the underlying data is a flag in the claims file that indicates whether the services were DIRECTLY related to the underlying disease (Ovarian cancer) using an algorithm and a 'Y' if true and null if not.
I can create the output I am looking for in a pivot table.
These numbers are all correct when run in SQL Server. The 0 is the false state which is running all of the data with no filtering (we call this "all cause". The -1 is the true state where the data has been filtered to include only those er services and costs that are directly attributable to this disease.
But, all I want to show is the -1 data andit actually should be showing the field name which is "ER/Urgent Care"
I have tried every which way to do this but cannot find the right way. Is there a reasonably easy way to suppress the 0 data values? Supressing zeroes does not remove that data/
I can live with the minus 1 and create an alternate name for it but I do not want both rows of this data in this particular table.
Re: Filtering a pivot table to show only the "true" values
Thanks to all of you for responding. I will definitely try all of these but the dimensions is already a calculated dimension so I will need to add these additional criteria. The current dimension is an If statement that includes both Disease_Specific='Y' and Service_Category = 'ER/Urgent Care'.
Can you include what u suggested in a conditional statement or can t be appended to the If statement? I could not find if there is a limit to how many criteria an If statement can handle. Would adding an AND make more sense?
Like I said. Really like the tool but do not have the syntax down.....yet.