Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-08-15 10:58 AM

How to sum with letters included?

Hallo everyone,

I am quite new to QlikView and I wonder if someone could help me with the following issue:

I would like to sum a colum which is easy. But now I have the problem that letters are in that same column. If I insert a sum formula the letters vanish to "0" what they shouldn't do. I need them there but not to be count.

Can anyone help, please?

Thank you very much in advance!

1,135 Views
17 Replies
Anonymous
Not applicable
‎2017-08-16 08:06 AM
Author

I am sorry, but it still is not the solution.

I think the main problem here is, that the text "abc" is not counted as number but as text so that all following numbers are not getting counted - not even horizontically.

300 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-08-16 08:10 AM

In response to vishsaggi

Have not done any testing, but I don't think it should give any performance differences....

300 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-08-16 09:32 AM

In response to Anonymous

Can you share your application and explain what you want in it?

300 Views
0 Likes
vishsaggi
Champion III
Champion III
‎2017-08-16 10:36 AM

In response to Anonymous

What you mean by below?

"I think the main problem here is, that the text "abc" is not counted as number but as text"

300 Views
0 Likes
Anonymous
Not applicable
‎2017-08-17 01:13 AM
Author

Hey everyone.

I try to sum and average the data below. My Problem is, when reading in the data, the "abc" is shown as "text" (Standing left). For the average the whole column does not get counted so that I get a wrong average. I want it to be written as text but the column should Count. I think that I am expressing myself too complicated. Sorry about that. I might find a Workaround solution.

   

JanFebMrzAprMaiJunJulAugSepOktNovDezØ
2,003,008,001,000,009,002,003,008,001,000,009,003,83
2,003,008,001,000,009,002,003,008,001,000,009,003,83
2,003,008,001,000,009,002,003,008,001,000,009,003,83
abc3,008,001,000,009,002,003,008,001,000,009,000,00
2,003,008,001,000,009,002,003,008,001,000,009,003,83
2,003,008,001,000,009,002,003,008,00abc0,009,000,00
2,003,008,001,000,009,002,003,008,001,000,009,003,83
2,003,008,001,000,009,002,003,008,001,000,009,003,83
2,003,008,001,000,009,002,003,008,001,000,009,003,83
300 Views
0 Likes
Colin-Albert
MVP
MVP
‎2017-08-17 04:35 AM

In response to Anonymous

Try this expression

if(dimensionality() = 0,

sum(if(isnum(Measure), Measure)),

if(isnum(Measure),sum(Measure), Measure)

)

measure_test.JPG

300 Views
0 Likes
sunny_talwar
MVP
MVP
‎2017-08-17 07:14 AM

In response to Anonymous

All you need to use here is to use Dimensionality() and SecondaryDimensionality() functions... Basically these functions will let you use different expressions for total vs. main expression.... Now, since the only thing you have been sharing is raw data, I don't know how your chart is structured, so it would be very difficult to give the exact expression. But see if you can work with this

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Or else share a sample of your app

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

300 Views
0 Likes
Anonymous
Not applicable
‎2017-08-21 07:17 AM
Author

Thank you very much for so much support!

I fixed my problem in using the rangesum function.

300 Views
0 Likes