topic Re: Chart: multiple dimensions in QlikView

Chart: multiple dimensions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the attached chart and also a screenshot below.

I would like to create a cyclic chart for Month and Week_Of. I just need to add a Week_of dimension that matches the formatting below. So, only show the last 3 of week_of values.

I've tried using a variable and cyclic but can't seem to get the Week_of dimension correct. Any help would be appreciated.

Re: Chart: multiple dimensions

Anonymous — Wed, 15 Feb 2017 15:26:51 GMT

any ideas

Re: Chart: multiple dimensions

marcus_sommer — Wed, 15 Feb 2017 16:09:12 GMT

A solution might be to use a cyclic group to switch between the dimensions whereby in your case a cyclic group directly in the chart would distort the layout and would be better to place the switch on the outside maybe within a listbox (they could be adjusted and overlapping the chart on an appropriate place) and the chart grabed the dimension per getcurrentfield().

Your approach to get the last or certain dimension-fields each will need some adjustments preferable with a flag within the script, maybe with something like:

autonumber(YearMonth) as PeriodID

autonumber(Week_of) as WeekID

within a sorted master-calendar and than an expression like:

count({< PeriodID = {">=$(max(PeriodID)-3)"}>} MBR_ACTIVE_CLT_CLT_PGMID)

- Marcus

Re: Chart: multiple dimensions

Wed, 15 Feb 2017 16:28:20 GMT

You can try something like this for most recent three weeks.

count({$<Datefield= {"$(='>=' & date(weekstart(today())-28))"}>}active members)

Replace weekstart(today) with month start if u r looking at last 3 months

count({$<Datefield= {"$(='>=' & date(Monthstart(today())-3))"}>}active members)