topic issue with straight table... need help please in QlikView

issue with straight table... need help please

Tue, 13 Jan 2015 07:04:54 GMT

hi all,

I have a weird issue with a straight table calculation.This was already developed and I am unabe to understand regarding a particular calculation.If you see my attached file,there is a table in it which has the first row under Ship Name column."Average per month".I am not able to understand how this is calculated??? I cannot find any of its relation in expressions/dimension. my script is not complete in the attachment as I cant share the complete of it.Is this calculation happening in script level or chart level,please can someone help me???

regards,

sahana

Re: issue with straight table... need help please

anbu1984 — Tue, 13 Jan 2015 07:18:45 GMT

Can you post qvw with less data or post your dimension and expr with sample data

Re: issue with straight table... need help please

Tue, 13 Jan 2015 08:15:52 GMT

hi,

I have reduced the data and reattached,now can you have a look and help me out please??

regards,

sahana !

Re: issue with straight table... need help please

Tue, 13 Jan 2015 09:06:57 GMT

can someone please help me with this issue??

Re: issue with straight table... need help please

tresB — Tue, 13 Jan 2015 09:19:14 GMT

That is 'Total' - row label. Goto presentation tab->Totals...

Re: issue with straight table... need help please

Tue, 13 Jan 2015 09:47:11 GMT

Hi Tresesco,

thanks!!!

but if you check in table "A",

The 1st column (Budget Avg per Ship)

value across "average per month"= the average of the 3 values in that column and not the total.

84,513

87,287

avg=

86,362

but in the 2nd column(Budget Avg) its just the total shown=

259,086

84,513

87,287

so how is this differentiation done??? where has the formula being executed please can you help me out....??? table B also has the same but the values are not matching

Re: issue with straight table... need help please

Tue, 13 Jan 2015 10:00:04 GMT

hi tresesco,

I found the solution its happening from expression tab itself.in total mode...

thanks for your response!!!

regards,

sahana

Re: issue with straight table... need help please

Tue, 13 Jan 2015 10:00:06 GMT

Hi Sahana,

If you see the Total Mode in expression tab, for first expression it is Avg where as second exp has Sum. I hope you need this differentiation.

hope this helps

Amay.