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: 
dcd123456
Creator
Creator

Accumulate diferents values

hello

I have a table with two fields date and user that have logged in an application to show a document, there is 6 diferents users, i need to show a line chart  with date as dimension and calculate how many diferents users day by day logon in the application to read the document but in accumulate way,

i need to know when all diferents users had readed the document at least one time.

i use the acumulate radio button of the expresion tab, but this sum all users and at the end the value is highest thant the max users.

i have attached an example.

Any body know how can i sum acumulate diferents users day by day.

regards

diego

1 Solution

Accepted Solutions
morganaaron
Specialist
Specialist

You can use an Aggr statement against the Date to return the minimum date found for each user, which would be the "first" time they access it - then when you're accumulating this would only count each user the first time they accessed.

Change your dimension to be:

Aggr(Date(Min(Date)), User)

Otherwise if you want to do this in your script, create a new resident table that calculates the minimum date per user, like:

Left Join ([Your Table Name])
Load
User,
Date(Min(Date)) as FirstAccessed
Resident Records
Group by User;

Then use "First Accessed" as your dimension, much as above.

View solution in original post

6 Replies
sunny_talwar

Are you looking to plot individual lines for each user?

Best,

S

sunny_talwar

This might be what you are looking for. PFA

Best,

S

morganaaron
Specialist
Specialist

You can use an Aggr statement against the Date to return the minimum date found for each user, which would be the "first" time they access it - then when you're accumulating this would only count each user the first time they accessed.

Change your dimension to be:

Aggr(Date(Min(Date)), User)

Otherwise if you want to do this in your script, create a new resident table that calculates the minimum date per user, like:

Left Join ([Your Table Name])
Load
User,
Date(Min(Date)) as FirstAccessed
Resident Records
Group by User;

Then use "First Accessed" as your dimension, much as above.

dcd123456
Creator
Creator
Author

Hello

I need a chart line where i can show evolution of days and how many diferents users have readed the document yet,

for example whe first day only 50% of the total users have reded yet  the document, the second day 97% of the users have readed the document and so on, and i can see that in the 3 first day near 99% of the users have readed the document....

i think this line char like a line with acumulate difrents users, but if i only use the  accumulated radio button QV sum all values, day by day... and if a user 1 logon in the first day, but logon in the second day again the QV in the second day acumulate the value 1+1...

i need that the  first day count diferents users of the first day, second day count diferents users of the first day and second day together, not sum diferents users of the first day + diferents users of the second day...

the file that i attached is only an example, in real i have mor than 2000 diferents users and 30 days....

i don't know if i explain my problem right...

thanks for your answers

best regards

diego

dcd123456
Creator
Creator
Author

Thaks very much it works.

best regards

diego

sunny_talwar

Earlier I misunderstood your problem, but I think, like morganaaron mentioned, it would be best to flag each user's first access in the script itself. Then you can use the flag in your set analysis.

Best,

S