Exchange dimension an calculated field

schumi1980 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have calculate the active portfolio of our share of premium according to segments A,B,C,D like this:

sum({<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)/sum(Total{<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)as [April Premium]

sum({<Inception={'<=31.3.2012'},Expiry={'>31.3.2012}>} Premium)/sum({<Inception={'<=30.6.2012'},Expiry={'>30.6.2012}>} Premium) as [June Premium]

and I am able to present them in Qlikview like this:

However, I would like to present the evolution of our portfolio like this:

I need like to be able to stack the segments A,B,C,B for each expression.

Is there a way to do that in Qlikview or do I have to load the data completely differently?

Many thanks for your help.

Schumi

Re: Exchange dimension an calculated field

Anil_Babu_Samineni — Wed, 26 Jul 2017 15:41:18 GMT

Sample attached? you can implement based on this?

Re: Exchange dimension an calculated field

schumi1980 — Wed, 26 Jul 2017 16:01:46 GMT

Hi Anil

Many thanks, it works perfectly, and it is so simple.

Best regards,

Jan

topic Re: Exchange dimension an calculated field in QlikView

Exchange dimension an calculated field

Re: Exchange dimension an calculated field

Re: Exchange dimension an calculated field