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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

How to get the expression correct ?

Hi All ,

Please kindly assist me to get my requirement correct. How to show the no of policy cancelled on UW_MONTH_KEY.

In Database , we have a Policy_cancellation_date. Say for eg , For UW_MONTH_KEY= 201909 which is fiscal_period . The policy count will occur if the policy_cancellation_date is also UW_MONTH_KEY i.e 201909.

Sample model attached.

 

Thanks in advance.

 

Labels (1)
0 Replies