Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
ramrongala
New Contributor

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

Re: How to avoid Text values in column

May be try this

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

Re: How to avoid Text values in column

No luck Bro..still get 0 only

Re: How to avoid Text values in column

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

ramrongala
New Contributor

Re: How to avoid Text values in column

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


@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
New Contributor

Re: How to avoid Text values in column

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

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

Re: How to avoid Text values in column

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
New Contributor

Re: How to avoid Text values in column

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.
Community Browser