topic Show total disregarding calculated dimension in QlikView

Show total disregarding calculated dimension

Mon, 25 Aug 2014 09:26:14 GMT

Hi all,

I need to show the last 15 dimension-values inside a chart-diagram which sums values. Showing the last 15 dimensions-values can be managed through a calculated dimension, but the sum is calculated for this dimension-values only.

However, I need to sum up the total, disregarding the calculated dimension.

Please see the attached screenshot and the QVW as example.

Any ideas?

Thanks,

Eva

Re: Show total disregarding calculated dimension

jagan — Mon, 25 Aug 2014 09:41:20 GMT

Hi,

Try like this

Dimension: YearWeek

Expression:

=If(RowNo()=1, $(=Sum({<YearWeek={'<= 201420'}>}Value)) ,

Sum({<YearWeek={'>= 201420'}>}Value))

Hope it helps you.

Regards,

Jagan.

Re: Show total disregarding calculated dimension

Mon, 25 Aug 2014 09:49:56 GMT

Hi Jagan,

this is working! Thank you 🙂

Regards,

Eva