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: 
xarapre7
Creator II
Creator II

Flags to work with the date cyclic group

Hi Experts!


I have Date flags (MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}) to determine the max(snapshots) in a year, month.


I have the below expression and it's only working when Year is selected in the cyclic group.


=Num(Count({$<Type={'A'}, MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}>} Distinct CaseID),'#,##0')


What is the correct expression to enable these flags to work with the date cyclic group wherein i have days, week, month and year? 


Thank you in advance.

4 Replies
Digvijay_Singh

In which chart you are trying? Not working means what? What does that flag means? From their names it looks like you are trying to filter Type 'A' cases in the last day of the year? Means it should show 0 for rest of the months and days?

A sample data or app should help to understand it further.

xarapre7
Creator II
Creator II
Author

Thank you for your reply.

Please see attached file for the sample data.  You'll find that when you select the month from the cyclic group, it would only show a month instead of 2 as there is Jan and also Feb months.  The flag for the year is preventing this from happening.

What should be the right set analysis/expression to use to show all the months or weeks when selected month or week from the cyclic group?

krishna_2644
Specialist III
Specialist III

Hi - As you can see in the below pic, you dont have any data for the month of Jan that satisfy the condition

MonthEndDateFlag={'1'} and LastMonthInYearFlag={'1'} but you have some data for feb.


Similarly you have some data for 2018 that satisfy  MonthEndDateFlag={'1'}, LastMonthInYearFlag={'1'}

1.PNG

xarapre7
Creator II
Creator II
Author

Krishna,

There isn't suppose to be any data for LastMonthInYearFlag for Jan as it is not the Last Month for the current year.  The expectation is that there should be 2 bars representing the 2 months.  What modification do i need in the expression to show that?