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: 
Anonymous
Not applicable

issue with the values

am encountering an issue in one of my application:

i have 3 text boxes:

first is displaying sum(x)

x is a field

second is displaying

sum({$<y={'N'}>}x)

y is another field which has values Y and N

third text box displaying values :

sum({$<y={'Y'}>}x)

so ideally the value displayed in the first text box shud be the sum of secnd and third text boxes

but its not happening,

what cud be the reason?

how i shud start digging into the problem means from where scirpt,front end selections etc,

kindly help and guide.

10 Replies
tresesco
MVP
MVP

This could be because your y field has few NULL values or some non-'X' or 'Y' values.

jduarte12
Partner - Creator II
Partner - Creator II

Do all the entries in x field have a match with 'Y' or 'N'?

neha_shirsath
Specialist
Specialist

Check for null values in y field.

Anonymous
Not applicable
Author

how to achieve the same

Anonymous
Not applicable
Author

i took x and y in a table box,i can see for some y values ,x values are showing null

and den i also tried to poulate some y values in x values

for eg:

  if(len(x)=0,'Y',x) as field1,

but no result out of this

and also there is one more expressions used:

other field with y field then again the same issue,

so there is some issue with this y field?

neha_shirsath
Specialist
Specialist

try with this-

=if(WildMatch(X,'',' '),'Y','X') as Field1

tresesco
MVP
MVP

Try like:

If( len(trim(x))=0, 'Z',x) as newX

If this doesn't help, try to share a sample qvw that depicts the issue.

sasiparupudi1
Master III
Master III

sum({$<y={'*'}-{'Y','N'}>}x)  to get null count

tresesco
MVP
MVP

'*' doesn't include null values.