Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
samvile18
Contributor II

Does anyone know why this won't work??

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.

3 Replies
MVP & Luminary
MVP & Luminary

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

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.


talk is cheap, supply exceeds demand
samvile18
Contributor II

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

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??

er_mohit
Honored Contributor II

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

Try this

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