topic Current vs Previous term - Urgent help if possible!! in QlikView

Current vs Previous term - Urgent help if possible!!

QlikBeginner1 — Sat, 16 Nov 2024 18:59:11 GMT

Hello.

I am creating a dashboard, and one of the features I want to implement is to have a page where it shows the total GWP for the Max Policy and the previous Policy, and to have the comparison.

Sum({<PolicyEffectiveDateCh = {"$(=Max(PolicyEffectiveDateCh))"}>} GrossWrittenPremium) - I currently am using this expression which calculates what I want, but only when I select a certain Policy. When I have not made a selection, the sum is not correct.

Sum({<PolicyEffectiveDateCh = {"$(=Max(PolicyEffectiveDateCh)-1)"}>} GrossWrittenPremium) - When I try this - I wanted to select the Max Policy Effective Date -1 to select the record before the Max record, however the output comes as 0, when I select a certain policy or when I have no selections?

Once I have these calculations, I am able to do the comparison between the two. Can anyone help me do a total GWP for each Max record of PolicyNumber? and then the prior record GWP?

Thanks

Re: Current vs Previous term - Urgent help if possible!!

Brett_Bleess — Thu, 02 Apr 2020 13:31:21 GMT

Have a look at the following Design Blog posts, believe they should be helpful on this one:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Here is the base link to the Design Blog area in case you want to search further on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

Re: Current vs Previous term - Urgent help if possible!!

yassinemhadhbi — Thu, 02 Apr 2020 23:45:51 GMT

Hello,

Try this

Sum({<PolicyEffectiveDateCh = {"$(=Max(PolicyEffectiveDateCh,2))"}>} GrossWrittenPremium)