I am creating a simple report in Qlik. I have created the QVD and pulling through the fields into the app.
I am trying to understand how to manipulate the report to show results based off some rules?
An example of some rules I am trying to implement are:
Compare Bound date and inception date: If Transaction date < Inception date then include in the report
If Transaction Type = “New Business” then include in the report extract if: Policy effective date > reporting date
If the Transaction Type = “Renewal” then include in the report extract if: Policy Effective date > reporting date
I have the Transaction Type dimension in the table, as well as effective date and the reporting date (reload date of the report). however I am trying to undestand how to implement those rules into the set anaylsis? Can someone please help to allow me to understand how to do this? I do have some measures, such as Sum (gwp) field. any help please would be greatly appreciated,