topic Re: issue with the values in QlikView

issue with the values

Anonymous — Wed, 09 Aug 2017 10:26:26 GMT

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.

Re: issue with the values

tresB — Wed, 09 Aug 2017 10:32:20 GMT

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

Re: issue with the values

jduarte12 — Wed, 09 Aug 2017 10:32:42 GMT

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

Re: issue with the values

neha_shirsath — Wed, 09 Aug 2017 10:47:16 GMT

Check for null values in y field.

Re: issue with the values

Anonymous — Wed, 09 Aug 2017 11:08:24 GMT

how to achieve the same

Re: issue with the values

Anonymous — Wed, 09 Aug 2017 11:16:38 GMT

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?

Re: issue with the values

neha_shirsath — Wed, 09 Aug 2017 11:21:38 GMT

try with this-

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

Re: issue with the values

tresB — Thu, 10 Aug 2017 04:56:57 GMT

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.

Re: issue with the values

sasiparupudi1 — Thu, 10 Aug 2017 05:23:16 GMT

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

Re: issue with the values

tresB — Thu, 10 Aug 2017 05:25:44 GMT

'*' doesn't include null values.

Re: issue with the values

sasiparupudi1 — Thu, 10 Aug 2017 05:50:20 GMT

Yes, I agree, thanks for correcting me.. But that expression should cater for empty values though