topic Re: Does anyone know why this won't work?? in QlikView

Does anyone know why this won't work??

samvile18 — Wed, 05 Jun 2013 08:38:01 GMT

Morning all,

I have the following syntax to count unique funds by distinct scheme, which is working fine...I can't however replicate it so it works with a sum.

=count({<FUND_Value={*}>}Distinct Distinct_ScheMemPolNo)

All I want to do is sum the total fund value by distinct scheme, any ideas anyone...it currently returns nothing, everything is blank.

Re: Does anyone know why this won't work??

Gysbert_Wassenaar — Wed, 05 Jun 2013 08:52:55 GMT

Try sum(FUND_Value). If you use scheme as a dimension in your chart then it will show the fund value sums per scheme value. If that's not what you want then you'll have to explain in more detail what should be the result. Preparing an example would help us find a solution for you.

Re: Does anyone know why this won't work??

samvile18 — Wed, 05 Jun 2013 09:26:31 GMT

A simple sum should work but for some reason the totals are coming out stupidly high...I've exported the raw data to excel and the same sum shows exactly what it should.

I'm really puzzled by this one...would it matter if the field I'm trying to sum is formatted as text and not number??

Re: Does anyone know why this won't work??

er_mohit — Wed, 05 Jun 2013 09:41:23 GMT

Try this

sum({1<FUND_Value={'*'}>}Distinct Distinct_ScheMemPolNo)