Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

prathipsrinivas
Contributor

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
prathipsrinivas
Contributor

Re: Limiting dimension values dynamically in Pivot table

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)

2 Replies
prathipsrinivas
Contributor

Re: Limiting dimension values dynamically in Pivot table

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)

Highlighted
prathipsrinivas
Contributor

Re: Limiting dimension values dynamically in Pivot table

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