topic Re: Dynamic dimension bucketing in QlikView

Dynamic dimension bucketing

punitpopli — Mon, 13 Oct 2014 15:12:05 GMT

Hi All,

I have a requirement where I have to show week ending date along with some measure value in bar chart, but the week ending date will be selected by users on run time.

The data presentation is like below:

the values must be summed up for every 4 week and Max() of week end date (i.e. out of 4) should be displayed as per the screen shot below (highlighted both week ending date and values background)

How to calculate the date range dynamically (i.e 4 weeks and their sum) on run time ?

Thanks in advance

Re: Dynamic dimension bucketing

Tue, 14 Oct 2014 08:29:54 GMT

Hi,

How many week ending dates a user is allowed to select. is it only one or he can select any number of week ending dates?

Re: Dynamic dimension bucketing

vikasmahajan — Tue, 14 Oct 2014 08:54:22 GMT

Week is there in your calender ?

Vikas

Re: Dynamic dimension bucketing

punitpopli — Tue, 14 Oct 2014 08:59:42 GMT

Shruthi Reddy : User can select any numbers of Weeks.

Vikas Mahajan : Yes, we have week ending date in our calender.

Please let me know if any other information required from my side.

Re: Dynamic dimension bucketing

vikasmahajan — Tue, 14 Oct 2014 09:04:04 GMT

you can try this expression

SUM(AGGR(Sum(Values),WEEKDAYS))

Vikas

Re: Dynamic dimension bucketing

punitpopli — Tue, 14 Oct 2014 09:54:47 GMT

Vikas Mahajan : We are not having data for each day, instead we have data on the basis of Week ending date (as shown in the example above) and we have to show accumulation of 4 weeks data on Y axis and the 4th week ending date on x axis (as highlighted in example above).

Please let me know fi any other information required.

Re: Dynamic dimension bucketing

vikasmahajan — Tue, 14 Oct 2014 11:25:35 GMT

pfa sample you need to apply rangesum command

Vikas