Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
priyankabahalia
Contributor
Contributor

HTML report

adding data from inception date finding the no of policies and premium  to qlik n printing html report want to know thw formula.

Labels (4)
1 Reply
Chirantha
Support
Support

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.