topic Re: Accumulate diferents values in QlikView

Accumulate diferents values

dcd123456 — Fri, 30 Jan 2015 10:51:55 GMT

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

Re: Accumulate diferents values

sunny_talwar — Fri, 30 Jan 2015 10:57:03 GMT

Are you looking to plot individual lines for each user?

Best,

Re: Accumulate diferents values

sunny_talwar — Fri, 30 Jan 2015 11:00:00 GMT

This might be what you are looking for. PFA

Best,

Re: Accumulate diferents values

morganaaron — Fri, 30 Jan 2015 11:07:19 GMT

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.

Re: Accumulate diferents values

dcd123456 — Fri, 30 Jan 2015 11:13:32 GMT

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

Re: Accumulate diferents values

dcd123456 — Fri, 30 Jan 2015 11:23:03 GMT

Thaks very much it works.

best regards

diego

Re: Accumulate diferents values

sunny_talwar — Fri, 30 Jan 2015 11:23:54 GMT

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,