Quarters missing dates

Lisa2 — Sat, 16 Nov 2024 00:54:44 GMT

Hello, I have a created, in my Load script,

'Q' & CEIL(NUM(MONTH([My End Date]))/3) AS QTR,

but when I make a list box to list the quarters, I get a lonely "Q" because some items don't have an end date. How do I get rid of this "Q"? Do I put something in the expression like a where clause, like where date is Null? If anyone could point me in the right direction. Thanks!

Re: Quarters missing dates

yassinemhadhbi — Thu, 02 Apr 2020 23:05:28 GMT

Hello,

you can try this

if(isnull([My End Date])=false(),'Q' & CEIL(NUM(MONTH([My End Date]))/3)) AS QTR

This Expression will make the script only calculates The quarter when there's an end date, and data with a null end date will still be loaded

topic Quarters missing dates in QlikView

Quarters missing dates

Re: Quarters missing dates