Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator II
Creator II

QuarterStart(Max(... and QuarterEnd(Max(... in Dimension

Hello,

can anyone help me and tell me how to properly use QuarterStart Max and QuarterEnd Max here in the dimension?

 

if(VST_Call.AnlageDatum >=Quarterstart(Max([VST_CallPosition.AnlageDatum]),-1) and VST_Call.AnlageDatum <=QuarterEnd(Max([VST_CallPosition.AnlageDatum]),-1) and VST_Call.xCallart= 12 and VST_CallPosition.x_Klasse= 100, [VST_Call.QVT_Tender_ID], null())

 

If I use Aggr, I get QuarterStart from all quarters 😞

Aggr(Quarterstart(Max([VST_CallPosition.AnlageDatum]),-1)

 

Labels (1)
1 Solution

Accepted Solutions
reporting_neu
Creator II
Creator II
Author

I have the solution 😄

VST_Call.AnlageDatum >= Aggr(Quarterstart(Today(),-1), VST_Call.Callnumber)

View solution in original post

1 Reply
reporting_neu
Creator II
Creator II
Author

I have the solution 😄

VST_Call.AnlageDatum >= Aggr(Quarterstart(Today(),-1), VST_Call.Callnumber)