i have one dimension in that dimension differnt id... - Qlik Community

Report Inappropriate Content · ‎2015-09-21

Hi all,

id

12abc34

5abc345

6rtd45

678abc

abc123

tyu12

qwta3

7ytu8a

34abc45

sunny_talwar · ‎2015-09-21

May be this:

=Count({<id = {'*abc*'}>} id)

sunny_talwar · ‎2015-09-21

or

=Sum(If(WildMatch(id, '*abc*'), 1, 0))

Update: Sample attached

Report Inappropriate Content · ‎2015-09-21

or

sum(if(SubStringCount(id,'abc')>0,1,0))

PrashantSangle · ‎2015-09-21

hi,

try

count({<id={"*abc*"}>}id)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ahmar811 · ‎2015-09-21

Sunny your statement is wrong

=Sum(If(WildMatch(id, '*abc*', 1, 0))

These should be

=Sum(If(WildMatch(id, '*abc*'), 1, 0))

sunny_talwar · ‎2015-09-21

Thanks for pointing out, but I did notice my mistake and made the change

Best,

Sunny

i have one dimension in that dimension differnt ids is there i want to find count of abc ids....