Create Line chart by using data as how many times user visit on website

[vlakeshr]

Hi ,

I want to create line chart by using data as user visit on website. Data field as below

Visit id,

loginid,

access date,

month,

Requirement is as below

To count how many times each user has visited the site in a month, and then group users by this count. For each count, we show how many users fall in that bucket.

A line chart plotted as follows

Y-Axis: User count

X-Axis: Number of Visits (the visit count group)

One line for each month.

I have created this in MS excel but not getting logic / idea as how to create in Qliksense.

I cannot touch to script and can't create variable as it is restricted to developer ( me)

Only can make changes in object formula to fulfill the requirement.

Could you please suggest / guide me to resolve this issue. Appreciate for your quick response.

Please find the attached data for reference which I have created for sample.

Cannot to share client data.

[vanessa_nery]

One line for each month or one line for each user?

[vanessa_nery]

Hello,

I created charts with your data. The .qvf is attached.

I hope this helps you.

Vanessa Nery.

[vlakeshr · Accepted solution]

I have create master dimension and used it to design the line chart & it's work.

Thanks for replied