Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Valued Contributor

Peek function to solve for X

Not sure if peek is the best way to do this, but what I am trying to figure out is looking at an organization, how many users does it take until there average sign in count per week is 1.

My initial thought is to sort by user and find there average, if it is not equal to 1 then move to the next line and find there average.  My only issue is that can you use peek to say, evaluate line 1, then evaluate lines 1 and 2, then evaluate lines 1, 2 and 3 and so on until your average equals 1.

Hopefully I am making sense, is there a way to do this?

1 Reply

Re: Peek function to solve for X

I don't understand what you're trying to do. Can you explain with some sample data what you're trying to calculate?

talk is cheap, supply exceeds demand
Community Browser