Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

About date and time appearance.

Hello;

I added qv screen  pictures,

I just want the yellow painted dates to be visible;

Please help.

Thank You.

dsds.png

Tags (1)
16 Replies
marcelviegas
Contributor II

Re: About date and time appearance.


Do you need the time, too?

marcelviegas
Contributor II

Re: About date and time appearance.

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;

Not applicable

Re: About date and time appearance.

Try this..

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

Re: About date and time appearance.

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

Not applicable

Re: About date and time appearance.

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.

Not applicable

Re: About date and time appearance.

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.

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

;

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

Re: About date and time appearance.

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

marcelviegas
Contributor II

Re: About date and time appearance.

rank(LoginT,Tarihl)