Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Quarters missing dates

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!

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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

View solution in original post

1 Reply
Highlighted
Contributor III
Contributor III

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

View solution in original post