topic Re: Create Line chart by using data as how many times user visit on website in QlikView

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

vlakeshr — Sat, 16 Nov 2024 20:44:56 GMT

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.

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

vanessa_nery — Fri, 31 May 2019 14:37:12 GMT

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

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

vanessa_nery — Fri, 31 May 2019 16:27:54 GMT

Hello,

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

I hope this helps you.

Vanessa Nery.

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

vlakeshr — Mon, 24 Jun 2019 09:24:18 GMT

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

Thanks for replied