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: 
ramrongala
Contributor II
Contributor II

How to avoid Text values in column

Hello Guys,

Please help on below problem.

i have one column(No of count) and i want sum the columns like =sum(No of count), its showing 0.

i tried different ways but no luck.

I want to sum or avoid text values in the columns.

sum=165, please have look below table and help me.  

 

No of count
2
3
5
9
20
30
96
Rana
testing

 

10 Replies
sunny_talwar

May be try this

Sum(Num#([No of count]))
ramrongala
Contributor II
Contributor II
Author

No luck Bro..still get 0 only
sunny_talwar

Would you be able to share a sample where we can see the issue?

ramrongala
Contributor II
Contributor II
Author

i want display sum in Text Object, its not coming from direct source.
we have implement roll back concept ie user enter some number in dashboard that values
saved in some db after one hour again it reflect our dashboard like column.
sunny_talwar


@ramrongala wrote:
i want display sum in Text Object, its not coming from direct source.

not coming from direct source? not sure I get any of what you have mentioned in your response?

ramrongala
Contributor II
Contributor II
Author

We have implement roll back concept in qlikview, ie we have given option for user to enter comment or value like input box, that values stored in DB, we will refresh every one hour,
user can see those values in dashboard after one hour. now i want some those values but unfortunately some users enter text instead of number.
i think now you got my point
sunny_talwar

Yup... but regardless oh what you are saying, I don't see why Sum([No of count]) didn't work for you... because it does for me

image.png

sunny_talwar

But if the field is all loaded as Text, then Sum([Text - No of count]) doesn't work... but this does

Sum(Num#([Text - No of count]))

image.png

ramrongala
Contributor II
Contributor II
Author

Hi bro ,
i took sample data and test its working but my application not working even count also wrong.
something is going on that column and i need to analyze.