topic Re: RE:Overall count in QlikView

RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:28:52 GMT

Hi all,

What wrng in my expression? in stright table.

Metric: distinc pass&fail for exec testid

and also apply modified date on condition to view he latest record.

=Count(

if(

Aggr

(

DISTINCT

(

max({<Exec_Status={'Passed','Failed'}>}Exec_ModifiedOn),

lvl_id,Period,Exec_TestID

)

=Exec_ModifiedOn

,Exec_TestID

))

)

Re: RE:Overall count

jagan — Fri, 29 Jan 2016 08:34:51 GMT

HI,

I am not sure what you are try to do with the expression, there are lot of syntax errors. = at the end of the expression,

Try this expression

=Count({<Exec_Status={'Passed','Failed'}>} Aggr(

max({<Exec_Status={'Passed','Failed'}>}Exec_ModifiedOn),

,lvl_id,Period

,Exec_TestID

))

If not working attach sample data and your expected output.

Regards,

Jagan.

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 08:35:16 GMT

Not really sure what the output requirement is but may be If needs to go within the Aggr?

May be this:

=Count(Aggr(DISTINCT If(Max({<Exec_Status={'Passed','Failed'}>}Exec_ModifiedOn) = Exec_ModifiedOn, Exec_TestID), lvl_id,Period, Exec_TestID))

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:39:59 GMT

my req is .... whenevr am selecing any filer in status ...it is gvng the exact count ....

meanwhile i hve clear all selections it is nt gvng exact count.

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 08:41:54 GMT

For each row you are not getting the correct count or the overall count at the top(or bottom) is getting calculated incorrectly?

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:42:19 GMT

and this exp

=Count(Aggr(DISTINCT If(Max({<Exec_Status={'Passed','Failed'}

and not IsNull(Exec_TestID)>}Exec_ModifiedOn)

= Exec_ModifiedOn, Exec_TestID), lvl_id,Period, Exec_TestID))

in exec_test id i hve nul id means some data hvng no id. how can i use exp with isnull?

Re: RE:Overall count

jagan — Fri, 29 Jan 2016 08:42:30 GMT

Hi,

If you attach sample data/file and your expected output then it is easier to give solution. Otherwise it is very difficult.

Not sure what dimensions are you using, datamodel etc.

Regards,

Jagan.

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:43:23 GMT

in each row getting correct values.....top total values are nt getting correct

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 08:44:53 GMT

Try this:

=Count(Aggr(DISTINCT If(Max({<Exec_Status={'Passed','Failed'}, Exec_TestID = {"=Len(Trim(Exec_TestID)) > 0"}>} Exec_ModifiedOn) = Exec_ModifiedOn, Exec_TestID), lvl_id,Period, Exec_TestID))

=Count(Aggr(DISTINCT If(Max({<Exec_Status={'Passed','Failed'}, Exec_TestID = {"=IsNull(Exec_TestID)) = 0"}>} Exec_ModifiedOn) = Exec_ModifiedOn, Exec_TestID), lvl_id,Period, Exec_TestID))

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:45:40 GMT

dimensions:

lvl id

period

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 08:46:32 GMT

Have you tried setting the Expression total using the third option available within total mode on expression tab of the straight table object's properties?

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:48:44 GMT

second exp is gvng entire values "0"

Re: RE:Overall count

jagan — Fri, 29 Jan 2016 08:49:02 GMT

Hi,

Try Sum of Rows option in Expression Tab for this expression.

Regards,

jagan.

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 08:49:28 GMT

What about the first one?

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 08:56:00 GMT

no sunny... nt gvng exact values

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 09:01:16 GMT

no luck

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 09:01:42 GMT

Have you tried playing with the total mode on Expression tab? Set as Sum of Rows may be?

Re: RE:Overall count

sunny_talwar — Fri, 29 Jan 2016 09:03:41 GMT

I guess, like Jagan has already said, would you be able to share a sample?

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 09:05:40 GMT

dat is also tried..not wrkng......only top of the total is nt shwng correct count...for perticular project only. remailng all shwng correct

Re: RE:Overall count

Chanty4u — Fri, 29 Jan 2016 09:13:00 GMT

when i select passed filter only the values of total count is nt gvng correct.....if i select fail it is gvng rows count and total also gvng correct