Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
kakani87
Valued Contributor

Count of Expression

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


if

(

count

(

{<

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

InOut={0}

>}

InOut

)

<>

count

(

{<

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

InOut={1}

>}

InOut

)

,

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

)

Tags (1)
1 Solution

Accepted Solutions

Re: Count of Expression

Something like this

Capture.PNG

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))

12 Replies

Re: Count of Expression

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kakani87
Valued Contributor

Re: Count of Expression

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 .

Minus.png 

Re: Count of Expression

Great, Would you able to share sample?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kakani87
Valued Contributor

Re: Count of Expression

Anil Find the File attached.

Re: Count of Expression

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))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
kakani87
Valued Contributor

Re: Count of Expression

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

Re: Count of Expression

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

Capture.PNG

kakani87
Valued Contributor

Re: Count of Expression

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.

Entries.png

kakani87
Valued Contributor

Re: Count of Expression

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