topic Re: sum of integer dimension in QlikView

sum of integer dimension

Fri, 16 Nov 2012 18:22:16 GMT

I had below mention expression in my earlier post and I was able to produce the result:

sum(aggr(sum({<[Item Type] = {"D"}>}DocDiscount) * num(Sum({<[Item Type] = {"D"}>}[Sales Price]) / Sum({<[Item Type] = {"D"}>} total<LocationCode> [Sales Price]),'#.##0.00%'),Tran_Year,Tran_Month,VoucherNo, LocationCode,Stock_Code))

But now In my another report I need to replace varchar dimenstion with below integer dimension.

discount <> 0 AND PCS > 1

So when I tryied to but I get error after <> sign

So anyone look into that and tell me what is wrong and how to form new expression with above mention condition.

Thanks

Re: sum of integer dimension

MayilVahanan — Fri, 16 Nov 2012 20:52:39 GMT

Where u using discount <> 0 , in if condition or set analysis

,if set analysis means, use like this

sum({<discount -={0},Pcs = {'>1'} >}Sales)

Hope it helps

Re: sum of integer dimension

Mon, 19 Nov 2012 17:54:48 GMT

Thanks for reply

But still I am getting RED underline (error) start from {0}

Re: sum of integer dimension

MayilVahanan — Mon, 19 Nov 2012 20:20:16 GMT

Thats bug in expression tab. but its shows expression ok on the expression tab. And give the result as you expected..

Hope it helps to understand it