topic Re: count column in QlikView

count column

Tue, 12 Jun 2012 14:14:07 GMT

i want to take sum of every column seperately. Do i have to write expression for all columns.

(you can see the excel format at the attachement)

thanks

edit: second version excell added

Re: count column

Tue, 12 Jun 2012 22:54:06 GMT

Hi,

regarding your data:

What is the second dimension of your matrix? I mean the first one looks like 'issue type', then what does each row in excel represent? Something like a flight?

Regards,

http://quickdevtips.blogspot.com

Re: count column

sivarajs — Wed, 13 Jun 2012 05:19:15 GMT

use rangesum(dim1,dim2....) in your expression

Re: count column

deepakk — Wed, 13 Jun 2012 06:09:27 GMT

hi,

Try the attach application.

Deepak

Re: count column

Fri, 22 Jun 2012 06:55:57 GMT

thanks a llot to all

Re: count column

Fri, 22 Jun 2012 07:12:47 GMT

Hi Deepak

your answer is very useful, but can you help again plase beacuse i added some columns and i want to see the sum by Tarih, Kalkış,Varış

these will be selectiosn criteria and fianlly i want to see the graphs in second sheet

thanks

Re: count column

deepakk — Fri, 22 Jun 2012 08:02:56 GMT

hi ,

Try the attach application