Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
adding data from inception date finding the no of policies and premium to qlik n printing html report want to know thw formula.
Hello Priyanka,
For example, if you have a field named Policy and another field named Premium, and you want to count the number of policies and sum the premiums since the inception date, your formula might look something like this:
Count({<Date={'>=$(=InceptionDate)'}>} Policy) & ' ' & Sum({<Date={'>=$(=InceptionDate)'}>} Premium).
This is just an example, and you would need to adjust it according to your data model and requirements.