Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

),BrokerageMonth)

2 Replies
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

),BrokerageMonth)

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