topic Re: Issue with Days displaying in QlikView

Issue with Days displaying

kakani87 — Fri, 05 Jan 2018 13:21:26 GMT

Dear All,

Kind Request to help me out of this issue.

I'm having a data of bio metric access from month of november to jan 1st but my requirement is to display attendance using smiley's in a chart and consider sunday as holiday using a flag sunday flag in calendar

like green as present and red as absent for max date.

Days 1 | 2 | 3| 4 | ...............

Dept | Emp | | | | ...

for day attendance as on max date like today.

Following is the expression I'm using to acheive the above requirement.

(

Count

(

DISTINCT

InOut={0},

CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'},

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

EmpID

)=1

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

(

max(SundayFlag)=1

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

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

)

Re: Issue with Days displaying

sunny_talwar — Fri, 05 Jan 2018 13:26:25 GMT

So what is wrong? Not sure I understand what is not working?

Re: Issue with Days displaying

kakani87 — Fri, 05 Jan 2018 13:46:55 GMT

for latest month of data only 1st jan entries available in the application max of date if we consider this should display only jan 1st according to my requirement the current month data to be displayed

according to this jan is max month and with in that only jan 1st is avail rite inspite of this it is displaying all days

and one more thing i need is grren as present and red as absent and some other colour as Sunday holiday for all should be shown

Re: Issue with Days displaying

sunny_talwar — Fri, 05 Jan 2018 13:53:29 GMT

Is this looking right?

If(Count(DISTINCT {<InOut={0}, CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'}, CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'}>} EmpID) = 1, 'qmem://<bundled>/BuiltIn/smiley1_g.png',

If(Max({<InOut={0}, CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'}, CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'}>}SundayFlag) = 1, 'qmem://<bundled>/BuiltIn/smiley1.png', 'qmem://<bundled>/BuiltIn/smiley3_r.png'))

Re: Issue with Days displaying

kakani87 — Fri, 05 Jan 2018 13:58:45 GMT

Yes Sunny this is right

Re: Issue with Days displaying

kakani87 — Sat, 06 Jan 2018 07:06:55 GMT

Sunny this is displaying only present in green smiley but suppose to display max month all days of an employee status green as present ,Red as absent and some other colour like grey to be indicated as sunday.

For now in application i'm having only jan 1st date for max month on that particular jan 1st couple of people they are absent this suppose to be indicate red.

Re: Issue with Days displaying

kakani87 — Mon, 08 Jan 2018 14:32:09 GMT

Hi Sunny,

Extended to the earlier discussion what we had in showing green smiley for present , red for absent the But the list of absent it is not showing the people who are absent and they suppose to be in red this is not displayed there. for the month of december if we filter then will come to know because all days displayed with in that if we can show show sunday flag on sunday as some other colour this will be helpful for me as per the requirement.

Could you kindly check with that once.

Regards,

Sai

Re: Issue with Days displaying

kakani87 — Mon, 08 Jan 2018 14:32:10 GMT

Hi Sunny,

Could you kindly check with that once.

Regards,

Sai

Re: Issue with Days displaying

kakani87 — Mon, 08 Jan 2018 14:32:10 GMT

Hi Sunny,

Could you kindly check with that once.

Regards,

Sai

Re: Issue with Days displaying

kakani87 — Mon, 08 Jan 2018 14:32:10 GMT

Hi Sunny,

Could you kindly check with that once.

Regards,

Sai

Re: Issue with Days displaying

kakani87 — Mon, 08 Jan 2018 14:35:21 GMT

Hi Sunny,

Extended to the earlier discussion what we had in showing green smiley for present , red for absent and Grey for sunday But the list of absent it is not showing the people who are absent and they suppose to be in red this is not displayed there for 1st jan max date. Inthe month of december if we filter then will come to know because all days displayed with in that if we can show show sunday flag on sunday as some other colour this will be helpful for me as per the requirement.

Could you kindly check with that once.

Regards,

Sai

Re: Issue with Days displaying

sunny_talwar — Tue, 09 Jan 2018 22:46:41 GMT

Try this

If(If(Only(TOTAL <CalendarFinancialYear> CalendarFinancialYear) = MaxString(TOTAL <CalendarFinancialYear>CalendarFinancialYear) and Only(TOTAL <CalendarDayOfMonth> CalendarDayOfMonth) = MaxString({<InOut={0}, CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'}, CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'}>}TOTAL <CalendarDayOfMonth>CalendarDayOfMonth),

Count(TOTAL <EmpID> DISTINCT {<CalendarFinancialYear, CalendarMonthAndYear>} EmpID) - Count(DISTINCT {<InOut={0}, CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'}, CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'}>} EmpID)) > 0,

'qmem://<bundled>/BuiltIn/smiley3_r.png',

Re: Issue with Days displaying

kakani87 — Wed, 10 Jan 2018 08:11:42 GMT

Here i would like to show something i found.

As this is a biometric data accessed details will be available. Here it is not displaying the day on sunday, if someone accessed on sunday then the day will be displayed.Apart from the people who accessed all they are displayed as red . The following attachment will give some clarity for the mont of dec 3rd and 10th they are sundays but on 3rd it is displaying entries because few are here and on 10th nothing is displayed not even the day.

Actually you are correct with the first post itself but my self failed to communicate properly

So now can we be able to show that this sunday as holiday indicator who are not in office.

Re: Issue with Days displaying

sunny_talwar — Wed, 10 Jan 2018 08:54:54 GMT

Just changed the order of the if statement....

If(Max(TOTAL <CalendarDayOfMonth>{<CalendarFinancialYear={'$(=Maxstring(CalendarFinancialYear))'}, CalendarMonthAndYear={'$(=maxstring(CalendarMonthAndYear))'}>}SundayFlag) = 1, 'qmem://<bundled>/BuiltIn/smiley1.png',

'qmem://<bundled>/BuiltIn/smiley3_r.png')))

For some reason your sample doesn't have 10-12-2017 and 24-10-2017... so that is why you don't see those in the pivot table at all... but if you add them from the back end, you should see them as grey...

Re: Issue with Days displaying

kakani87 — Wed, 10 Jan 2018 09:32:09 GMT

Thank you Sunny This is exactly i needed

Re: Issue with Days displaying

sunny_talwar — Wed, 10 Jan 2018 09:33:14 GMT

Awesome!!

Please close the thread by marking correct and helpful responses

Best,

Sunny