Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Set Analysis on year and month

Hi,

I have a requirement where in the sheet user select

Year and month on the basis of selection the straight table perform and give sum of sales

Eg:-

Current Year Selection = 2012 and Current Month Selection = Dec

In Straight table

Dimension -> Dealer

expression1 -> Sum of sales of previous year 2011 and month Dec

expression2 -> Sum of sales of current year 2012 and month Oct

expression3 -> Sum of sales of current year 2012 and month Nov

expression4 -> Sum of sales of current year 2012 and month Dec

But problem comes when user select month "Jan"  then expression will be for

expression1 -> Sum of sales of previous year 2011 and month Dec

expression2 -> Sum of sales of current year 2011 and month Nov

expression3 -> Sum of sales of current year 2011 and month Dec

expression4 -> Sum of sales of current year 2012 and month Jan

Please help for this

Thanks

Tags (2)
2 Replies
Not applicable

Re: Set Analysis on year and month

Hi,

Any one help me for this.

Thanks

Ritul

Not applicable

Re: Set Analysis on year and month

Could you show which expressions are you using?

To calculate the month before you should use Addmonths() function if using a date type, or get a correlative number for months if using a number type.

Sent from mobile