topic Re: prior period comparison in QlikView

prior period comparison

omyahamburg — Fri, 12 Apr 2013 13:17:43 GMT

Hello all

Can someone help ? My head is blocked by end of this week.

I have a table where I show a sum for a dimension Periode:

Periode is coming out of my script:

year (Date)&'-'&month(Date) as Periode

How to I write the expression to sum Restmenge for 2012-Jan and so on ?

Thanks for your help.

Joerg

kaushiknsolanki — Fri, 12 Apr 2013 13:37:11 GMT

Hi,

Instead of

year (Date)&'-'&month(Date) as Periode

Create a filed Periode as Monthname(Date) as Periode.

This will result into Mar 2013 and so on.

Now You can use below expression to get the last month data.

=sum({<Periode= {"$(=Monthname(addmonths(max(Date),-1)))"},Year=>}Sales)

Regards,

Kaushik Solanki

omyahamburg — Fri, 12 Apr 2013 13:54:44 GMT

Dear Kaushik

Thank you, I'll try latest on Monday and will let you know.

best regards

Joerg