Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I have create master dimension and used it to design the line chart & it's work.
Thanks for replied
Hello,
I created charts with your data. The .qvf is attached.
I hope this helps you.
Vanessa Nery.
I have create master dimension and used it to design the line chart & it's work.
Thanks for replied