Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dunnalahk123
Creator III
Creator III

Max and MIn in set analysis

Hi

i am writing below condition for min and Max in set analysis

 

Sum({<Month ={">=201802 <=201904"}>}NumValue)

 

My point is Q118 should not come as i am taking month greater than 201802 which Q2FY18 , but for me Q118 is coming and only data is coming as 0 but for me Q118 itself should not come.

 

Any idea or suggestion please.

Q.PNG

 

Best Regards,

HK

3 Replies
saar_lorena
Contributor III
Contributor III

As I understood from your formula, you are taking month bigger than 201802 or equal than 201802.

Another solution could be include your column data in your expression as below, instead of using hard code:

=Sum({<Period ={">=$(=min(Period))<=$(=max(Period))"}>}NumValue)

dunnalahk
Contributor III
Contributor III

Hi,

Thank You.

 

Actually i have min date as 201711  in my report which is my Quarter Q118 starting month , i want to show Quarters only from Q218  so i am giving 201802 which is my Q2 Starting Month.

danilostochi
Creator II
Creator II

first transforms the field into the script using monthstart ()
+55(44) 9 9993-3605, WhatsApp
E-Mail or Skype - danilo16stochi@hotmail.com