topic Getting totals from straight table in QlikView

Getting totals from straight table

Mon, 14 Apr 2014 10:44:41 GMT

Hi Guys,

I've got one stupid question to ask, but I have to do that.

Is that possible to get total sum of rows from straight table and use it somewhere else? I'm trying to create a text field with sum o f two sums from different objects. I'm using expressions from the straight tables, but I can't get proper values from the second one (because expressions are complicated). I know here should be to have the expressions working. I'm just asking.

Please see my attached image where I put what I need. Thanks in advance for any answer.

Regards,
Paweł

Re: Getting totals from straight table

jonasheisterkam — Mon, 14 Apr 2014 10:52:59 GMT

You can use a macro but this must run every time the table change.

Have you look for aggr()-function to build the value outside the diagram?

Re: Getting totals from straight table

preminqlik — Mon, 14 Apr 2014 11:07:19 GMT

sum(aggr(<Expression>,Dimension1,dimension2))

Re: Getting totals from straight table

vipin_mishra479 — Mon, 14 Apr 2014 11:43:55 GMT

please attached some sample

Re: Getting totals from straight table

Mon, 14 Apr 2014 12:33:33 GMT

Hi Vipin,

Could you please attach your file again?

Thank you in advance.

Regards,

Paweł