topic Re: PREVIOUS MONTH in QlikView

PREVIOUS MONTH

sagaraperera — Thu, 18 Jun 2015 03:06:19 GMT

Hi All,

I need help...

I want to calculate current month and previous month. Eg. Suppose all data is selected then values show current month(May) data and previous month(April) data, and if user click on April month filter then variable need to show current month as April and previous month as March. Hope you understand the requirement.

SAGARA

MY SCRIPT

CrossTable(DESCRIPTION, ACTUAL, 6)

LOAD BCOD,

MONTH,

YEAR,

MONTH2,

CLA_CODE,

MONM,

GROSS_PREMIUM,

Re: PREVIOUS MONTH

Chanty4u — Thu, 18 Jun 2015 03:29:09 GMT

hi perera,

Max(year) give you may

min(year) gives u jan

May(year)-1 give this filter u vil get previous mnth whn user cliks.

hope this helps u

Thank u

Suresh

Re: PREVIOUS MONTH

gautik92 — Thu, 18 Jun 2015 06:28:40 GMT

Max of Month with Year

upper(Date(Max({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))}>}Transactiondate),'MMM-YY'))

max of Month-1 with Year

upper(Date(Max({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID)-1)}>}Transactiondate),'MMM-YY'))

Re: PREVIOUS MONTH

hariprasadqv — Thu, 18 Jun 2015 06:32:53 GMT

Give an Id for months and get max(mid) and max(mid)-1