topic Re: How to handle Date in QlikView

How to handle Date

Sun, 11 Nov 2012 09:19:36 GMT

Please find the attached application.

Description:

========

Basically its a game scenario where each Game has a duration of 28 days.

UID: User ID

GID: Game ID

PID: Player ID

G_ST_DT: Game Start Date

G_ED_DT: Game End Date

Requirement:

=========

I need a new column which tells me about number of Games Repeat by the user.

I tried to solve it by still getting problems,so, if anyone could help me that would be great ...

Re: How to handle Date

IAMDV — Sun, 11 Nov 2012 09:27:28 GMT

Hi,

Not quite understood your question. What is the field for user? Is it UID? and what is the link between two tables. Can you tell the answer for your question based on your Excel example? I mean expected results for a specific User and we can get this working in QlikView.

Thanks,

www.QlikShare.com

Re: How to handle Date

Sun, 11 Nov 2012 09:43:15 GMT

yes UID is for User, Discard the second table (i.e: Repeat) i just used as a result for testing purpose.

Just focus on Temp1 ..

Considering Excel Example: There is a User having an UID : 1 , user 1 involved in 5 games G1,G2,G3,G4,G5

on diferent dates (as you can see from the dates Game Star Date And Game End Date)

I just want to find out that how many games that the User 1 has repeat after played first game

Re: How to handle Date

IAMDV — Sun, 11 Nov 2012 09:51:41 GMT

Gotcha! So from your example UID played 4 games and the result should be 4 or what is the expected result here?

Thanks,

www.QlikShare.com

Re: How to handle Date

IAMDV — Sun, 11 Nov 2012 10:22:20 GMT

Not sure if I'm missing something but it should be straightforward expression...

IF(Count({1} UID) >= 1, Count({1} UID) -1, 0)

Please see the attachment and it give 4. Also, I'm using the {1} to ignore all the seleciton and count full set.

Thanks,

www.QlikShare.com

Re: How to handle Date

Sun, 11 Nov 2012 10:58:09 GMT

thnks

Re: How to handle Date

IAMDV — Sun, 11 Nov 2012 10:59:18 GMT

Is this what you need?

Thanks,

Re: How to handle Date

renjithpl — Sun, 11 Nov 2012 14:12:01 GMT

I have not understood your questions,

but is it something like this which you are looking for

Game:

LOAD UID,

GID,

PID,

date(G_ST_DT, 'DD/MM/YYYY') as GameStartDate,

date(G_ED_DT, 'DD/MM/YYYY') as GameEndDate,

num((G_ED_DT-G_ST_DT)) as duration,

if(num((G_ED_DT-G_ST_DT)) /28 >1, 'Repeated', 'Not repeated') as RepeatStatus

FROM

[qlikview examples try\test(1).xlsx];

regards

Renjith

Re: How to handle Date

IAMDV — Tue, 13 Nov 2012 16:10:47 GMT

Is this resolved? Managed to get it to work? If yes, please mark the correct answer as answered.

Thanks,