# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Exclude master dimension in Qlik Sense

Hi Guys,

I need to exclude selections of an master dimension (DueMonth) in the bar chart in Qlik Sense. But, the exclusion is not working as I'm applying exclusion on master dimension. Please let me know how can I fix this?

Master dimension (Duemonth) expression:

Measure expression in Bar chart is Sum({<DueMonth=>}sales).

1 Solution

Accepted Solutions
Honored Contributor II

## Re: Exclude master dimension in Qlik Sense

let's try to replace with this expression:

=Aggr( Only( {< DueDate= >} if(DueMonth<=(Date(monthstart(addmonths(Today(),6)), 'MMM-YY')), DueMonth ) ), DueMonth )

and the below as measure:

Sum( {< DueDate= >} Sales )

Let me know.

BR

7 Replies
Valued Contributor III

## Re: Exclude master dimension in Qlik Sense

Hi Manoj,

Kindly explain with example so we can understand your query.

Thanks,

Arvind Patil

Honored Contributor II

## Re: Exclude master dimension in Qlik Sense

let's using the below calculated dimension:

=Aggr( Only( {< DueMonth= >} if(DueMonth<=(Date(monthstart(addmonths(Today(),6)), 'MMM-YY')), DueMonth ) ), DueMonth )

I hope it helps.

Highlighted
Contributor

## Re: Exclude master dimension in Qlik Sense

Thanks Guys for your response. Sorry for not making this question clear.

lets take an example. I am using inline load as below. I've created a master dimension (Duemonth) and it is being used in the filter and the table. Selections in the filter should not affect Bar chart. so I've added measure (Sum({<DueMonth=>}Sales)) to Bar graph to exclude selections of Duemonth. But it is not working.

//Master dimension to restrict Duemonth only till next 6 months

Issue:

Sales,date(DueDate) as DueDate,

(Date(monthstart(DueDate), 'MMM-YY')) as DueMonth

inline

[

Id,Country,Dept,Sales,DueDate

1,US,Sales,10,'18/02/2018'

1,US,IT,20,'28/08/2018'

2,IN,Sales,45,'24/05/2018'

2,IN,HR,35,'18/06/2019'

];

Honored Contributor II

## Re: Exclude master dimension in Qlik Sense

did you try to replace your master dimension with the expression i gave you?

Contributor

## Re: Exclude master dimension in Qlik Sense

Yes Andrea, But its not working.

Honored Contributor II

## Re: Exclude master dimension in Qlik Sense

let's try to replace with this expression:

=Aggr( Only( {< DueDate= >} if(DueMonth<=(Date(monthstart(addmonths(Today(),6)), 'MMM-YY')), DueMonth ) ), DueMonth )

and the below as measure:

Sum( {< DueDate= >} Sales )

Let me know.

BR

Contributor

## Re: Exclude master dimension in Qlik Sense

Thanks Andrea. It worked.