topic Count of Expression in QlikView

Count of Expression

kakani87 — Wed, 17 Jan 2018 10:01:51 GMT

Dear All,

There is an expression with me which to display with a Image/Symbol now what i want is to display is the count where it is displaying the image//Symbol Following is the expression

(

count

(

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={0}

InOut

)

count

(

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={1}

InOut

)

'qmem://<bundled>/BuiltIn/minus_r.png'

)

Re: Count of Expression

Anil_Babu_Samineni — Wed, 17 Jan 2018 11:03:38 GMT

Expression looks good, What is the issue? Have u changed Representation from text to image?

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 11:15:48 GMT

Hi Anil ... This expression will display the image i want but my intention is to display the count.

lets say in the below image it is displayed '-' symbol in red now i want to show the total count of Red highlighted Minus Image count .

Re: Count of Expression

Anil_Babu_Samineni — Wed, 17 Jan 2018 11:18:46 GMT

Great, Would you able to share sample?

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 11:27:26 GMT

Anil Find the File attached.

Re: Count of Expression

Anil_Babu_Samineni — Wed, 17 Jan 2018 11:36:06 GMT

Can you check this for first one, Whether the result same as you expected, Expression here

count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={0}>}InOut)-

Count(Aggr(if(count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={0}>}InOut)<>

count({<CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},InOut={1}>}InOut),1,0),Location, DepartmentName, EmpName, tran_date))

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 11:37:01 GMT

Anil ... Shared File could you check with this Count.

Re: Count of Expression

sunny_talwar — Wed, 17 Jan 2018 12:10:46 GMT

Don't we already see all the minus signs with 1?

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 12:19:14 GMT

This Giving some Wrong numbers Anil.

I will explain you little Clearly Exactly in previous image it is displaying entries of access not done properly by an employee lets he is IN and Out in ratio 3:2 then it is displaying that Minus symbol in a day like that an employee access who are not punching properly due to tail gating and some other reasons

Note Where Work Station Gate entry Should be Ignored Due to only in access can be swiped but not the exit swipe avail in that gate.

Attached is a sample to explain you

Here shown an employee in and out entries are not proper Check this On 9th jan entries are like this

in order to track this entries How many days an employee has done this

Hope i explained you clearly.

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 12:22:32 GMT

Need to show the count of all the Minus Symbols of an employee this shows how many days he i irregular in punching properly

Re: Count of Expression

sunny_talwar — Wed, 17 Jan 2018 12:26:08 GMT

When you say all, you mean sum the number of days? So Day won't be a dimension when you see this?

Re: Count of Expression

sunny_talwar — Wed, 17 Jan 2018 12:29:28 GMT

Something like this

Try this

Sum(Aggr(if(count({<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={0}

>}InOut)

count({<

CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'},

InOut={1}

InOut ),1,0), Location, DepartmentName, EmpName, tran_date))

Re: Count of Expression

kakani87 — Wed, 17 Jan 2018 12:43:07 GMT

This meets my requirement let me check and update.