how to use aggregation function without group by

Mon, 02 Nov 2015 06:27:31 GMT

Hi ,

I have a piece of code and its throwing invalid expression error when i execute it.I am not using group by on the basis of count function. Thats why its showing error.But i dont want to use group by here dats my requirement.

Please let me know how can i achieve the above requirement.

load

'$(i)' as Month,

fd_code as [Client source],

if(pri_code=1 and wc_code= '01' and wo_Diff <='1' ,count(wo_number)) as [No Of Work Orders 1]

if(pri_code=1 and wc_code = '01' ,count(wo_number)) as [No Of Work Orders 1.1],

if(pri_code=2 and wc_code = '01' and wo_Diff <=2,count(wo_number)) as [No Of Work Orders 2]

from $(vQVDDataDir)\XYZ.qvd (qvd)

where num(month(floor(wo_completionDate))) >= '$(i)'-1 and num(month(floor(wo_completionDate))) <= '$(i)' and year(floor(wo_completionDate))='2015'

and isnull(proj_number) and pri_code='$(j)' and wc_code = '$(j)' and wo_Diff <='$(j)'

group By

fd_code;

Thanks,

Vasudha Mishra

Re: how to use aggregation function without group by

Gysbert_Wassenaar — Thu, 05 Nov 2015 15:03:36 GMT

If you don't want a group by then don't add any fields that aren't aggregated. You're using fd_code, pri_code, wc_code and wo_Diff without aggregating them, so these fields must be part of the group by clause. There is NO way to do it otherwise.

topic how to use aggregation function without group by in QlikView

how to use aggregation function without group by

Re: how to use aggregation function without group by