Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
reporting_neu
Creator III
Creator III

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 III
Creator III
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 III
Creator III
Author

I have the solution 😄

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