Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
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

Prathip
Labels (1)
1 Solution

Accepted Solutions
prathipsrinivas
Creator
Creator
Author

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)

Prathip

View solution in original post

2 Replies
prathipsrinivas
Creator
Creator
Author

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)

Prathip
prathipsrinivas
Creator
Creator
Author

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

Prathip