Create a Days After chart based on specific x-axis numbers

Anonymous — Mon, 12 Oct 2015 17:52:57 GMT

I am trying to create a line chart that shows the number of times a video has been viewed after its initial release date. I have two tables:

Release:

Vid_Num,

Release Date

and

View:

Vid_Num

View_Date

I left joined the View table to the Release table and did

(View_Date - Release_Date) as Days_After

to get the number of days after Release date. All of this worked perfectly and I was able to graph it using Full Accumulation to show the growth in views, but my issue is I want a specific x axis that shows the release dates as 7, 14, 21, 30, 60, 90, 120, 150, ... 1080 days after release. I was able to show a static 30 day interval by changing the static min, max and step, but i want to add 7, 14, and 21 as well.

Thanks!

Re: Create a Days After chart based on specific x-axis numbers

Anonymous — Tue, 20 Oct 2015 21:02:14 GMT

I was able to get it to work by adding

=ValueList(7,14,21,30,60,90,120,150,180,210,240,270,300,330,360,390,420,450,480,510,540,570,600,630,660,690,720,750,780,810,840,870,900,930,960,990,1020,1050,1080)

in the dimension. It works for now but if anyone has a better solution, please let me know. The expression is changed to embedded if statements. I attached the new graph.

Thanks!

topic Create a Days After chart based on specific x-axis numbers in QlikView

Create a Days After chart based on specific x-axis numbers

Re: Create a Days After chart based on specific x-axis numbers