topic Re: get some based on values in a certain colum in QlikView

get some based on values in a certain colum

anuradhaa — Fri, 05 Feb 2016 04:51:36 GMT

I have below data set

Id tag hours

1 5

g 12

2 10

I want to get sum of id hours (5+10 =15) and sum of tag hours (12)

jonathandienst — Fri, 05 Feb 2016 05:00:07 GMT

Something like this:

Sum({<Id={*}>} hours)

Sum({<tag={'*'}>} hours)

PradeepReddy — Fri, 05 Feb 2016 05:14:57 GMT

for ID Hours--> sum( if(len(trim((Id)))>0,hours))

For Tag Hours --> sum( if(len(trim((tag)))>0,hours))