How to get rid of unwated data from Finter pane in Qlik Sense?
I am new to Qlik sense. I am in learning process. Here I have a problem with filter pane.
In my model, I have used 3 dimensions and 1 fact. Below are table names
1. Dim COA
2. Dim Account
3. Dim Calendar (Tran Date Calendar, Post Date Calendar)
4. Fact Transactions
In above model I used Dim Calendar two times. One for Tran date calendar table and one for Post Date calendar. I used this model for create a qlik sense report.
For example if an Account doesn't have any transactions in Fact table, I still can able to see that account number in report with 0 as measure value. I can able to get rid of this kind of data from report by uncheck option in 'Data Handling' in 'Add-on' properties. When I come to filter pane I don't have 'Add-on' properties for Filter pane. Please help me how to handle this kind of situation.