Quarterwise as at expression

[#1]

how to write as at expression for quarterwise in pivot table without writing if conditions.QlikTech Admin

[its_anandrjs]

Hi,

You mean to say that without creating Quarter field in load statement you want to use field in dimension.

Thanks & Regards

[ashwanin]

use Ceil to define Quarter

e.g 'Q'&Ceil(num(Month(Date))/3) as Quarter,