Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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