topic Re: How to avoid Text values in column in Water Cooler

How to avoid Text values in column

ramrongala — Thu, 10 Jan 2019 14:00:05 GMT

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

Re: How to avoid Text values in column

sunny_talwar — Thu, 10 Jan 2019 14:05:22 GMT

May be try this

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

Re: How to avoid Text values in column

ramrongala — Thu, 10 Jan 2019 14:09:09 GMT

No luck Bro..still get 0 only

Re: How to avoid Text values in column

sunny_talwar — Thu, 10 Jan 2019 14:10:06 GMT

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

Re: How to avoid Text values in column

ramrongala — Thu, 10 Jan 2019 14:15:24 GMT

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.

Re: How to avoid Text values in column

sunny_talwar — Thu, 10 Jan 2019 14:19:24 GMT

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

Re: How to avoid Text values in column

ramrongala — Thu, 10 Jan 2019 14:27:45 GMT

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

Re: How to avoid Text values in column

sunny_talwar — Thu, 10 Jan 2019 14:33:26 GMT

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

Re: How to avoid Text values in column

sunny_talwar — Thu, 10 Jan 2019 14:34:54 GMT

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]))

Re: How to avoid Text values in column

ramrongala — Fri, 11 Jan 2019 06:44:39 GMT

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.

Re: How to avoid Text values in column

sunny_talwar — Fri, 11 Jan 2019 12:03:46 GMT

Awesome, I hope you will be able to find the issue.

Best,
Sunny