topic Re: problem in not like syntax in count function in QlikView

problem in not like syntax in count function

saivina2920 — Sat, 16 Nov 2024 21:18:33 GMT

I'm trying to get count of values from specific column.

i'm able to get count if i use like condition. example is below.

=count(distinct [ColumnA] like '%TOTAL PROFIT%')

Suppose if want to get not like '%TOTAL PROFIT%', then

what would be the syntax or different logic would be use..?

Re: problem in not like syntax in count function

Anil_Babu_Samineni — Tue, 05 Mar 2019 10:05:28 GMT

Not sure, How your expression is working? May be try this way?

count(distinct {<[ColumnA] -= {'*TOTAL PROFIT*'}>} [ColumnA])

Re: problem in not like syntax in count function

saivina2920 — Tue, 05 Mar 2019 10:23:20 GMT

Thanks for your reply.
I tried the below.
count(distinct {<[ColumnA] -= {'*TOTAL PROFIT*'}>} [ColumnA])
but both matching and non-matching showing the same count. i have different records.
How it is possible.

Re: problem in not like syntax in count function

saivina2920 — Wed, 06 Mar 2019 08:05:36 GMT

any update...

Re: problem in not like syntax in count function

saivina2920 — Wed, 13 Mar 2019 10:40:35 GMT

Great...