How to get rid of unwated data from Finter pane in Qlik Sense?

[#1]

Hello Experts,

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.

Thanks in advance

--Hari

[OmarBenSalem]

Can you share an image of your problem? What do you want to eliminate?
Thanks !

[OmarBenSalem]

Till then, If I fully understand you.

I have sthing similar to that;

I have a field called : Year

a Measure : Sum("Car Sales")

Suppose I choose a bar chart:

Dimension: Year

Measure : Sum("Car Sales")

The result would be:

Since there is no car sales before 2005; I want to eliminate those years from the chart.

We go to complement and uncheck the null values and the work is done :

Now, in the other hand, and even so there is no Car Sales before 2005, when we Add the Year field as a filter pane, we will see all the Years:

The question is How to eliminate these unwanted Years?

Let's ask it a different way; What are the Years we want to eliminate?

=> The Years that have no Car Sales in them:

In other work, If Sum of car sales by year =0 , then replace the Year field by Null, else, if there is sales: keep the Year value:

The expression would be as follow:

=if(aggr(Sum({1}[Car sales]),Year)=0,Null(),Year)

Let's create it a master dimension and use it as a filter:

Hope this answers your question!

Omar,