topic Re: Flags to work with the date cyclic group in QlikView

Flags to work with the date cyclic group

xarapre7 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Flags to work with the date cyclic group

Digvijay_Singh — Sat, 03 Mar 2018 03:36:33 GMT

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.

Re: Flags to work with the date cyclic group

xarapre7 — Sat, 03 Mar 2018 07:10:20 GMT

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?

Re: Flags to work with the date cyclic group

Qrishna — Sat, 03 Mar 2018 07:24:40 GMT

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'}

Re: Flags to work with the date cyclic group

xarapre7 — Sat, 03 Mar 2018 17:55:08 GMT

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?