topic About date and time appearance. in QlikView

About date and time appearance.

Wed, 25 Nov 2020 16:16:04 GMT

Hello;

I added qv screen pictures,

I just want the yellow painted dates to be visible;

Please help.

Thank You.

Re: About date and time appearance.

marcelviegas — Wed, 16 Aug 2017 20:14:18 GMT

Do you need the time, too?

Re: About date and time appearance.

marcelviegas — Wed, 16 Aug 2017 20:20:41 GMT

modifica em seu script:

load

[ADI SOYADI],

[user name],

TarIh,

Baslangic,

min(Login) as Login

from table

group by [ADI SOYADI],[user name],TarIh,Baslangic;

Re: About date and time appearance.

Thu, 17 Aug 2017 05:37:33 GMT

Try this..

aggr(date(Min(Login),'DD.MM.YYYY hh:mm:ss'),[ADI SOYADI],[user name],TarIh,Baslangic)

Re: About date and time appearance.

avinashelite — Thu, 17 Aug 2017 05:44:05 GMT

Could you please explain the requirements ?? you need to display only certain dates and hide the rest ? if so that the condition for displaying and hiding the date

Re: About date and time appearance.

Thu, 17 Aug 2017 09:40:06 GMT

Hello;

I Use;

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb];

LOAD "Agent Name",

"Login ID" ,

Extn,

min("Login Time")as Login,

"Logout Time",

"Logout Reason",

Date("Login Time",'D.M.YYYY') as Tarih,

ApplyMap('Map', "Login ID",'Diğer') as "ADI SOYADI",

ApplyMap('Map1', "Login ID",'Diğer') as Baslangıc,

ApplyMap('Map1', "Login ID",'Diğer') as Bitis;

SQL SELECT *

FROM "C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb".Login

group by [ADI SOYADI],"Login ID",Tarih,Baslangıc;

But was no solution.

I need yellows line.

Re: About date and time appearance.

Thu, 17 Aug 2017 09:46:07 GMT

Are u tried this in front end

Try this..

aggr(date(Min(Login),'DD.MM.YYYY hh:mm:ss'),[ADI SOYADI],[user name],TarIh,Baslangic)

Re: About date and time appearance.

Anil_Babu_Samineni — Thu, 17 Aug 2017 10:00:13 GMT

Try this?

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb];

Map:

Mapping Load....;

LOAD "Agent Name",

"Login ID" ,

Extn,

min("Login Time")as Login,

"Logout Time",

"Logout Reason",

Date("Login Time",'D.M.YYYY') as Tarih,

ApplyMap('Map', "Login ID",'Diğer') as "ADI SOYADI",

ApplyMap('Map1', "Login ID",'Diğer') as Baslangıc,

ApplyMap('Map1', "Login ID",'Diğer') as Bitis group by [ADI SOYADI],"Login ID",Tarih,Baslangıc;

SQL SELECT *

FROM "C:\Users\07008557\Desktop\LoginLogout\Data\LoginLogout.accdb".Login

;

Re: About date and time appearance.

Thu, 17 Aug 2017 12:24:47 GMT

I tried your suggestions but it did not succeed. I added the file as an attachment to the first message. Can you check.

Re: About date and time appearance.

marcelviegas — Thu, 17 Aug 2017 12:53:57 GMT

rank(LoginT,Tarihl)

Re: About date and time appearance.

Thu, 17 Aug 2017 13:02:48 GMT

unsuccessful. Only yellow min values should be visible

Re: About date and time appearance.

vishsaggi — Thu, 17 Aug 2017 14:10:28 GMT

Or this?

= FirstSortedValue(LoginT, Aggr(Tarihl, [ADI SOYADI], [Login ID], Tarihl ))

Re: About date and time appearance.

Thu, 17 Aug 2017 17:50:45 GMT

Hello,

thank you for the answer, resolution approaching, but I have 1 problem.

1-) [ADI SOYADI] Ex: Abd.1.8.2017 it seems but, 2.8.2017 not seems.

Ex table:

Re: About date and time appearance.

vishsaggi — Thu, 17 Aug 2017 21:03:13 GMT

Will this work? If not may be stalwar1‌ be of any help.

Re: About date and time appearance.

Fri, 18 Aug 2017 06:14:38 GMT

problem is not solved.

Re: About date and time appearance.

PrashantSangle — Fri, 18 Aug 2017 07:08:16 GMT

Hi,

Can you try with below modification.

Date("Login Time",'D.M.YYYY') as Tarihl,

Replace above line with

Date(Floor("Login Time"),'D.M.YYYY') as Tarihl

then in front end

take straight table

dimesion

1: ADI SOYADI

2: Tarihl

Expression:

Timestamp(min(LoginT))

Regards,

Prashant Sangle

Re: About date and time appearance.

antoniotiman — Fri, 18 Aug 2017 09:09:53 GMT

HI,

maybe this

Regards,

Antonio