topic Re: not is null in QlikView

not is null

gr_eldred — Tue, 17 Oct 2017 21:57:49 GMT

I need to apply a count of a concatenated field but one of them contains a null try this but it has not been successful, can you help me ?.

count(Distinct Pto_vta_ID&%Folio_Fac)

Greetings.

sunny_talwar — Tue, 17 Oct 2017 22:44:08 GMT

Not sure what the issue you are running into because of null, but may be try this

Count(DISTINCT If(Len(Trim(Pto_vta_ID)) > 0, Pto_vta_ID, '@') & If(Len(Trim(%Folio_Fac)) > 0, %Folio_Fac, '@'))

gr_eldred — Tue, 17 Oct 2017 23:07:13 GMT

I continue with the same problem appears in the first row

sunny_talwar — Tue, 17 Oct 2017 23:21:19 GMT

You don't want to count it?

gr_eldred — Tue, 17 Oct 2017 23:23:43 GMT

the first row that comes empty I do not want to tell

sunny_talwar — Tue, 17 Oct 2017 23:29:44 GMT

You don't want to count that? May be this

Count(DISTINCT If(Len(Trim(Pto_vta_ID)) > 0 and Len(Trim(%Folio_Fac)) > 0, Pto_vta_ID&%Folio_Fac))

gr_eldred — Tue, 17 Oct 2017 23:44:05 GMT

just what I needed, thank you very much.

Anil_Babu_Samineni — Wed, 18 Oct 2017 01:22:32 GMT

You can try this way too? Create field in script.

If(Len(Trim(Pto_vta_ID)) > 0 and Len(Trim(%Folio_Fac)) > 0, 1,0) as Flag

And set Analysis should be like below

Count({<Flag = {1}>} Pto_vta_ID&%Folio_Fac)

Anil_Babu_Samineni — Wed, 18 Oct 2017 01:23:20 GMT

You can mark Correct answer of sunny's latest reply. That may useful to others when they land-up to the same thread.