topic Re: Restrict Month in QlikView

Restrict Month

Wed, 19 Aug 2015 11:22:09 GMT

Hi Experts,

I have a Month field which is from Jan 2015 till Aug 2015

I need to add this dimension into a pivot table.

But I need to restrict it to 3 months. i.e., i need only June 2015 to Aug 2015 to be added to the Month field in the table not in the script.

Actual Requirement

how can i do this.

Please provide me suggestions.

jduarte12 — Wed, 19 Aug 2015 11:24:08 GMT

Hi,

In the dimension limits tab, try to impose onle the max 3 months.

Regards

Kushal_Chawda — Wed, 19 Aug 2015 11:30:16 GMT

Create MonthName field in Script using

monthname(date#(Month,'MMM YYYY')) as MonthName

Create the Pivot Table

Dimension:

MonthName

Expression:

Sum({<MonthName={">=$(=addmonths(max(MonthName),-2))<=$(=addmonths(max(MonthName),0))"}>}Sales)

You can modify your expression as per your logic

gautik92 — Wed, 19 Aug 2015 11:30:26 GMT

try this

in sort tab use load order reversed and in dimension limit tab show only first 3 values