topic Re: get current month vs previous month in QlikView

get current month vs previous month

arulsettu — Fri, 26 Sep 2014 06:35:52 GMT

i am trying to show current month vs previous month in bar chart

what i did is

sum({<FiscalPeriod={$(=max(FiscalPeriod)),$(=max(FiscalPeriod)-1)}>}Customer)

it shows maximum month and previous month

how can i show current vs previous month any help?

Re: get current month vs previous month

sushil353 — Fri, 26 Sep 2014 06:39:46 GMT

Try this:

sum({<FiscalPeriod={"<=$(=max(FiscalPeriod)) >=$(=max(FiscalPeriod)-1)"}>}Customer)

Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 06:42:45 GMT

it showing the same

Re: get current month vs previous month

sushil353 — Fri, 26 Sep 2014 06:52:28 GMT

what are the values in your FiscalPeriod..

Can u post a sample data

Re: get current month vs previous month

Fri, 26 Sep 2014 06:53:16 GMT

I think , you can get the current month and then compare.

like something below:

sum({<FiscalPeriod={"<=$(=Month(date(today()))) >=$(=Month(date(today()))-1)"}>}Customer)

if format is different ,change the format of month accordingly.

Regards,

Raksha

Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 06:55:18 GMT

months

1 2 3 4 5 6 7 8 9 10 11 12

Re: get current month vs previous month

anbu1984 — Fri, 26 Sep 2014 06:55:36 GMT

Can you post sample qvw

Re: get current month vs previous month

senpradip007 — Fri, 26 Sep 2014 06:59:10 GMT

Try like

Sum({<FiscalPeriod={">=$(=MonthStart(AddMonths(Max(FiscalPeriod),-1))) <=$(=Max(FiscalPeriod))"} >} Customer)

Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:00:52 GMT

it shows every month

Re: Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:06:11 GMT

here

Re: Re: get current month vs previous month

Fri, 26 Sep 2014 07:10:08 GMT

I have attached sample QVW . Hope this helps.

Regards,

Raksha

Re: Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:13:05 GMT

sorry using personal edition

can you post the code

thanks

Re: get current month vs previous month

Fri, 26 Sep 2014 07:20:25 GMT

Your FisicalPeriod only include the Month part of the date.

Try to create another field using MonthStart

Then you can select current month instead of like September for every previous years.

Thank you

Re: get current month vs previous month

senpradip007 — Fri, 26 Sep 2014 07:21:09 GMT

Try like:

Sum({<FiscalPeriod={'$(=Max(FiscalPeriod)-1)), $(=Max(FiscalPeriod))'} >} Customer)

Re: Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:25:09 GMT

it shows nothing

Re: Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:26:01 GMT

can you show me how

Re: get current month vs previous month

PrashantSangle — Fri, 26 Sep 2014 07:28:15 GMT

Hi,

Write 2 expression:

1st for Current Month:

sum({<FiscalPeriod={"=$(=max(FiscalPeriod))"}>}Customer)

2nd for Previous Month:

sum({<FiscalPeriod={"=$(=max(FiscalPeriod)-1)"}>}Customer)

Regards

Re: get current month vs previous month

senpradip007 — Fri, 26 Sep 2014 07:28:38 GMT

Try like:

Sum({<FiscalPeriod={$(=Max(FiscalPeriod)-1)), $(=Max(FiscalPeriod))} >} Customer)

Re: get current month vs previous month

jyothish8807 — Fri, 26 Sep 2014 07:29:36 GMT

Hi Arul,

Your script looks good to me.

Max(month) and current (month) will be same. if you dont have entries of current month then you wont be able to get current month.

Regards

Re: Re: get current month vs previous month

arulsettu — Fri, 26 Sep 2014 07:31:29 GMT

its showing every month