Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

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
Gysbert_Wassenaar

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
Creator III
Creator III
Author

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
Master II
Master II

Try this

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