topic Re: count expression in QlikView

count expression

Wed, 11 Mar 2015 07:47:38 GMT

Hello community,

sorry, I couldn't think of a better title

I have various EnvNames in different files. Now I want to find out if EnvNames are missing in a file.

In below screenshot I have a straight table. I would like to change the background color of the 2nd column if the count

is below the count of all filenames.

So in this example only EnvA with a count of 4 would be green, the rest is red.

I can't figure out the if-statement to get this job done.

Hope you can help me out.

Thank you,

Thorsten

Re: count expression

jagan — Wed, 11 Mar 2015 07:57:58 GMT

Hi,

Try like this

Chart Properties -> Expressions -> Click on + symbol of expression and select Background -> Give this statement in that

=If(Count(Distinct FileName) = 4, Green(), Red())

If not working attach some sample file.

Hope it helps you.

Regards,

Jagan.

Re: count expression

chrislofthouse — Wed, 11 Mar 2015 08:09:36 GMT

Re: count expression

Thu, 12 Mar 2015 08:43:30 GMT

both of you use the hardcoded 4. How can I change this into an expression?

If I use count(DISTINCT FileName) everything turns green. I also tried count( {1} [FileName]) without luck.

Re: count expression

chrislofthouse — Thu, 12 Mar 2015 11:21:13 GMT

count(total DISTINCT FileName)

Re: count expression

jagan — Mon, 16 Mar 2015 02:44:10 GMT

Hi,

Try like this

=If(Count(Distinct FileName) = count(TOTAL DISTINCT FileName), Green(), Red())

Regards,

Jagan.

Re: count expression

Anonymous — Mon, 16 Mar 2015 04:48:49 GMT

Hi,

Try this it will help you,

Chart Properties -> Expressions -> Click on + symbol of expression and select text colour -> Give this statement in that

If(Count(Distinct FileName) = Aggr (Count(Distinct FileName),FileName), Red(),Green())

Hope this will work.

Thanks and Regards,

Amarnath

Re: count expression

timanshu — Mon, 16 Mar 2015 05:32:04 GMT

Hi Thorsten,

Do This:

Define a Variable

Example : vMax =Max(aggr(Count(EnvName),EnvName))

Then,

In chart expressions , expression which gives count of EnvNames, define its background as if(Count(EnvName)=vMax,Green(),Red()).

This Works.

Re: count expression

timanshu — Thu, 19 Mar 2015 04:53:27 GMT

Hi Thorsten,

Can you let me know how this expression worked:

=If(Count(Distinct FileName) = count(TOTAL DISTINCT FileName), Green(), Red())

or just attach qvw.

I am trying to make this work but it's not working.