topic Re: last 4 weeks data in bar graph in QlikView

last 4 weeks data in bar graph

Mon, 04 May 2015 09:56:09 GMT

Hi all,

I have a data like below. i need the results in bar graph.

invitation_id date_created user_signed course_completed

1 02-04-2015 1 1

2 12-04-2015 1 1

3 20-04-2015 0 0

4 25-04-2015 1 1

5 26-04-2015 1 0

6 27-04-2015 1 1

7 28-04-2015 1 0

8 29-04-2015 1 1

9 01-05-2015 1 1

10 02-05-2015 1 1

11 03-05-2015 1 1

12 03-05-2015 1 0

i am using measures like:

1. count({$<course_completed={1}>}[invitation_id])

2. count({$<user_signed={1}>}[invitation_id])

3. count(invitation_id)

I need bar graph on week basis. last 4 weeks data.

and also for last 7 days. please help me.

Thanks,

Pramod

Re: last 4 weeks data in bar graph

Peter_Cammaert — Mon, 04 May 2015 11:45:28 GMT

Use Dimension Limits.

Select Show First 4 Values, based on a date field or a range field with an attached date value.

Do not forget to Sort the dimension from Last to First

Peter

Re: last 4 weeks data in bar graph

Mon, 04 May 2015 12:05:07 GMT

hi peter,

I am not getting. will u please explain it briefly. and how it is used

Pramod

Re: last 4 weeks data in bar graph

Peter_Cammaert — Mon, 04 May 2015 12:10:37 GMT

Well, since you are using week-related dimension values, there should be some underlying date value (like e.g. WeekStart()) Use that value to sort the X-axis from Latest to Earliest. The underlying date value includes a year, so you won't get into trouble with multiple years (like you mentioned in your other discussion on the same topic)

Then add ad dimension limit that limits the number of X-axis values to the first four. Or first seven in case of day values.

Re: last 4 weeks data in bar graph

Mon, 04 May 2015 12:26:58 GMT

peter i got it. i am asking how can i add that limit. through expression or something else?

Re: last 4 weeks data in bar graph

Peter_Cammaert — Mon, 04 May 2015 13:08:15 GMT

Right-click on your bar chart, select Properties->Dimension Limits

Peter

Re: last 4 weeks data in bar graph

Mon, 04 May 2015 13:10:50 GMT

are you explaining in qliksense right. i am not getting the "properties".

Re: last 4 weeks data in bar graph

Peter_Cammaert — Mon, 04 May 2015 13:13:12 GMT

This is a QlikView discussion, so I'm explaining what you get in QlikView Desktop.

Peter