Hi, I have a variable called QTR which I defined as = Quarter([Year]) where year is a column in my sales table. This seems to work fine until when I tried to use QTR as a quick filter in the top of the page, it doesn’t seem to have any effect in that all QTR values 1,2,3,4 remains displayed no matter what value I choose in the LOV. I’m using webi XI 3.1, anybody have any idea what I’m doing wrong ? thanks…
iwanhp (BOB member since 2009-11-16)
Hiya
The input param for the Quarter() function is a date and not a year so this may be causing some issue.
I am on XIR2 and tried your scenario out
Query = year, month, date, measure 1
Remove date from the table
Created qtr variable as quarter([date]) and brought inot the table.
Initially this displayed #FORMAT but changing the number format sorted that one out.
Created a quick report filter to select just qtr 2 and it worked fine.
SandiR 
(BOB member since 2004-12-20)