topic Expression count by value in QlikView

Expression count by value

realpixel — Wed, 09 Oct 2013 18:26:04 GMT

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

Re: Expression count by value

Gysbert_Wassenaar — Wed, 09 Oct 2013 18:28:43 GMT

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

Re: Expression count by value

realpixel — Thu, 10 Oct 2013 07:49:40 GMT

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

Total=162

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

Re: Expression count by value

Thu, 10 Oct 2013 07:51:37 GMT

will you pleasee post your sample app

Re: Expression count by value

Thu, 10 Oct 2013 08:01:10 GMT

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

Re: Expression count by value

Thu, 10 Oct 2013 08:01:20 GMT

can you give sample data ?

Re: Expression count by value

realpixel — Thu, 10 Oct 2013 08:23:45 GMT

Hello,

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

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

Like that

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

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

162

Re: Expression count by value

tresB — Thu, 10 Oct 2013 08:31:16 GMT

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

Re: Expression count by value

Thu, 10 Oct 2013 08:32:18 GMT

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

Re: Expression count by value

Thu, 10 Apr 2014 10:28:57 GMT

try the following expression:

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

hope it will work..

Re: Expression count by value

its_anandrjs — Thu, 10 Apr 2014 11:24:01 GMT

If in database in fields all values start with EX and you want to count then then use

=Count(if(left(HMDAU,2) = 'EX', HMDAU))

And gwassenaar give correct suggestion.

Re: Expression count by value

MayilVahanan — Thu, 10 Apr 2014 11:36:19 GMT

For your requirement you can use like this

HMDAU As dimension

Then count({<HMDAU={'EX*'}>}HMDAU) as Expression.. // For Count

MaxString({<HMDAU={'EX*'}>} HMDAU) as expression. // For Value

In your case, try second solution