topic Re: Unable to get total in chart table for one column in QlikView

Unable to get total in chart table for one column

markgraham123 — Thu, 23 Jul 2015 14:28:36 GMT

Hi,

I have 3 dimensions Name, Total and used.

In the chart table, im using an expression (Used/total)%

I can get the total as sum of rows for total and used.

But the same logic not working for the expression where i want to fetch the overall %.

Can someone look into the app atatched.

sunny_talwar — Thu, 23 Jul 2015 14:31:32 GMT

Use the same logic for the third expression? If you need Avg then select Avg like this:

Qrishna — Thu, 23 Jul 2015 14:32:52 GMT

Summing up all the %s seems to be a bad logic. but u can do something like avg,max min of the %s.

see attached.

Anonymous — Thu, 23 Jul 2015 14:35:10 GMT

the expression for Total should be :

sum(Total)

the expression for Used should be :

sum(Used)

then in the 3rd column put:

column(2)/column(1)

Then use expression totals for all 3 columns

sunny_talwar — Thu, 23 Jul 2015 14:39:10 GMT

Or may be this:

Where 74.52% = 459761/616973

Expression:

Sum(Aggr(Used, Name))/Sum(Aggr(Total, Name))

Anonymous — Thu, 23 Jul 2015 14:41:03 GMT

Sorry, forgot to attach the example

markgraham123 — Thu, 23 Jul 2015 14:52:13 GMT

Thanq Adrian.

markgraham123 — Thu, 23 Jul 2015 14:52:22 GMT

Thanq CHaitanya

markgraham123 — Thu, 23 Jul 2015 14:52:31 GMT

Thanq Sunny.

sunny_talwar — Thu, 23 Jul 2015 14:53:42 GMT

No problem, I am glad I was able to help.

Best,

Sunny