Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kakani87
Specialist
Specialist

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'

)

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

12 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Specialist
Specialist
Author

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 

Anil_Babu_Samineni

Great, Would you able to share sample?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Specialist
Specialist
Author

Anil Find the File attached.

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Specialist
Specialist
Author

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

sunny_talwar

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

Capture.PNG

kakani87
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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