Re: Expression count by value - Qlik Community

realpixel · ‎2013-10-09

Hello,

I have a column in chart named HMDAU, I want to count only all value begenning by 'EX******'

Someone have an idea how to do?

Thank

Gysbert_Wassenaar · ‎2013-10-09

count({<HMDAU={'EX*'}>}HMDAU)

talk is cheap, supply exceeds demand

realpixel · ‎2013-10-10

Hello,

Thank you for your reply

This expression give me the result but not the list value begining by EX********

For example in my chart I have

HMDAU

0

Total=162

The total is correct but in the chart the value is 0 and not EX*******

Report Inappropriate Content · ‎2013-10-10

will you pleasee post your sample app

Report Inappropriate Content · ‎2013-10-10

Hi,

Mr, Wassenaar's answer should work, do you have any sample of your source and what your table should look? or screenshots.

Regards,

Alex

Report Inappropriate Content · ‎2013-10-10

can you give sample data ?

realpixel · ‎2013-10-10

Hello,

See Under the result, is not possible to have the value beginning by 'EX*******' in place of the numeric value " 1 "?

Like that

count({<HMDAU={'EX*'}>}HMDAU)

EX****************

162

tresesco · ‎2013-10-10

I guess you are trying with a chart. If so, then try with Only()/Concat() functions, like:

=Only({<HMDAU={'EX*'}>} Distinct HMDAU) // if you want single value per row

Report Inappropriate Content · ‎2013-10-10

Hi,

create a straight table

on your dimension tab select "HMDAU" (or whatever your table name is)

on your Expression tab paste this

if( Dimensionality() = 1,

only({<HMDAU = {'AA*'}>}HMDAU),

count({<HMDAU= {'AA*'}>}HMDAU))

Then go to Presentation tab

click your dimension then click "Hide column" below

Regards,

Alex

Report Inappropriate Content · ‎2014-04-10

try the following expression:

=if(wildmatch(HMDAU,'EX*'),count(HMDAU))

hope it will work..