How can I create 4 monthly views in QlikView?

[shamitshah]

Hi,

I need to set up a list box with 4 monthly periods in addition to the quarterly periods which have already been set up in QlikView.

What is the best way going about setting this up?

Thanks

Shamit

[Chanty4u]

can u explain more with sample data?

[#3]

"4 Monthly Periods", does it mean you need to divide each month in 4 equal period?

[shamitshah]

I currently have the following in the script for quarters:

'Q' & (mod(Ceil(Month(Date)/3)+1,4)+1) as Quarter

However , I require a trimester breakdown as well. Is it simply a matter of adding an additional line as

'Q' & (mod(Ceil(Month(Date)/4)+1,4)+1) as TQuarter ?

Thanks

Shamit

[#5 · Accepted solution]

Hi Shamit,

For trimester, I don't think +1 in your expression is required.

If I consider:

Jan, Feb, Mar, Apr - 1

May, Jun, Jul, Aug - 2

Sep, Oct, Nov, Dec - 3

Then 'Q' & (mod(Ceil(Month(Date)/4),4)) would resolve the issue.

Thanks!

[CarlosAMonroy]

Hi,

Ceil(Month(Date)/4) would do it.

Thanks,

Carlos

[shamitshah]

Thanks Carlos,

That works as well.

Shamit