Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
manojkumargowda
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:

if(DueMonth<=(Date(monthstart(addmonths(Today(),6)), 'MMM-YY')),DueMonth)

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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
Partner
Partner

Re: Exclude master dimension in Qlik Sense

Hi Manoj,

Kindly explain with example so we can understand your query.

Thanks,

Arvind Patil

Partner
Partner

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.

manojkumargowda
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

DueMonth=if(DueDate<=(addmonths(Today(),6)),DueMonth)

Issue:

Load Id,Country,Dept,

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'

];

Partner
Partner

Re: Exclude master dimension in Qlik Sense

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

manojkumargowda
Contributor

Re: Exclude master dimension in Qlik Sense

Yes Andrea, But its not working.

Highlighted
Partner
Partner

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

manojkumargowda
Contributor

Re: Exclude master dimension in Qlik Sense

Thanks Andrea. It worked.