topic Re: Expression Issue with Count of values in QlikView

Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 16:05:43 GMT

Please find the attachment

I want the output as count(column (C))='MET'/total count of (Column (C))

i.e., 3/6 = 2 to be shown in a text box.

would appreciate your help

Re: Expression Issue with Count of values

krishnacbe — Wed, 08 Mar 2017 16:10:09 GMT

Try below Expression

Count(C)/Count({<C={"MET"}>}C)

Re: Expression Issue with Count of values

sunny_talwar — Wed, 08 Mar 2017 16:19:06 GMT

Shouldn't it be the opposite?

Count({<C={'MET'}>}C)/Count(C)

Re: Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 16:46:32 GMT

Can anyone give me a sample qvw with the above example

Re: Expression Issue with Count of values

sunny_talwar — Wed, 08 Mar 2017 16:50:42 GMT

Here you go...

Re: Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 16:59:10 GMT

Thanks Sunny

Re: Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 17:01:15 GMT

One more question on the same

if MET and NOT MET are calc values based on the A and B, how do you get this value

Re: Expression Issue with Count of values

sunny_talwar — Wed, 08 Mar 2017 17:02:37 GMT

Can you share an example to explain what you mean

Re: Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 17:16:21 GMT

Attached my example...

Re: Expression Issue with Count of values

pipuindia99 — Wed, 08 Mar 2017 17:16:56 GMT

I need the same value to be in a text box

Re: Expression Issue with Count of values

sunny_talwar — Wed, 08 Mar 2017 17:21:21 GMT

May be this:

=Count({<name={"=A=B"}>}name)/Count(name)

Re: Expression Issue with Count of values

pipuindia99 — Thu, 09 Mar 2017 08:53:48 GMT

It is not working

Re: Expression Issue with Count of values

sunny_talwar — Thu, 09 Mar 2017 09:46:24 GMT

Have you looked at the attached sample? Seems to be working for me unless you have a different data model in your original app

Re: Expression Issue with Count of values

pipuindia99 — Thu, 09 Mar 2017 10:06:40 GMT

I downloaded the attachment, it looks different what i gave it to you . but still i managed with your suggested expression. it doesnot work for me. to be more meticulous i have used dimension(name) as separate table and in expression i have added 3 expression like (exp1 - with pick match functions, exp2 - with pick match function, exp3 - exp1 compared to exp2...) and i would like to show the values in text table as required.

please help

Re: Expression Issue with Count of values

sunny_talwar — Thu, 09 Mar 2017 10:11:03 GMT

My bad, may be I might have added the wrong qvw file

Re: Expression Issue with Count of values

pipuindia99 — Thu, 09 Mar 2017 10:19:05 GMT

Have sent you the requirement to your email id...