topic Ignoring calculated dimensions in chart in QlikView

Ignoring calculated dimensions in chart

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

Hi All.

I have attached sample data in the excel file to explain what I am trying to do.

I am trying to create a chart that shows Incurred Loss and Earned Premium. The Incurred Loss works fine and is by Loss Type. But the Earned Premium should be at the Line level.

Loss Type is a calculated dimension. I have included my expressions in the excel file (as well as qvw).

For Earned Premium I used TOTAL <Line> but I am not sure how to ignore Loss Type which is a calculated dimension. The Earned Premium should be the total for the Line and repeat for all Loss Types.

Any help is appreciated.

Thanks

Shariq

Re: Ignoring calculated dimensions in chart

sunny_talwar — Sun, 03 Dec 2017 07:00:55 GMT

May be this

If(Dimensionality() = 0,

Sum({<Flag_YTD = {1}, Year = {'$(=max(Year))'}>} [Earned Premium]),

Aggr(NODISTINCT Sum({<Flag_YTD = {1}, Year = {'$(=max(Year))'}>} [Earned Premium]), Line))

Re: Ignoring calculated dimensions in chart

shariqusmani — Sun, 03 Dec 2017 18:38:50 GMT

Thanks Sunny! Exactly what I was looking for.