Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Limiting dimension values dynamically in Pivot table

Hi Folks,

I want to restrict the Dimension values (which has month names like Dec 2018).

I just want use only last two month's names to be used in the pivot table.

I have tried something like this but doesn't work.

=if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth

)

Could anyone please throw some light on how to achieve so.

Thanks in advance,

Prathip

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

It's working as expected when I just added aggr.

Now it looks like this:-

=aggr(if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth

),BrokerageMonth)

View solution in original post

2 Replies
Highlighted
Creator
Creator

It's working as expected when I just added aggr.

Now it looks like this:-

=aggr(if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth

),BrokerageMonth)

View solution in original post

Highlighted
Creator
Creator

It's working as expected when I just added aggr.

Now it looks like this:-

=aggr(if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth