topic Aggregated measure based on custom X-axis Scale in QlikView

Aggregated measure based on custom X-axis Scale

shyamcharan — Fri, 06 Mar 2015 03:14:04 GMT

Hi Experts,

I have a requirement where the user should be able to change steps of the X-axis scale like he can use 250 or 500 or 1000 etc..

I was able to achieve it with a few variables, however, the graph does aggregate based on the scale. I want the graph to be aggregated or modified based on the x-axis values.

Can someone please suggest how i can achieve this?

thanks in advance.

Regards,

Shyam.

Re: Aggregated measure based on custom X-axis Scale

Gysbert_Wassenaar — Fri, 06 Mar 2015 10:23:59 GMT

See attached qvw. Is that what you want?

Re: Aggregated measure based on custom X-axis Scale

shyamcharan — Fri, 06 Mar 2015 23:29:05 GMT

Thanks Gysbert. That works like magic.

Could you please share what made this work?

Thanks heaps.

Regards,

Shyam.

Re: Aggregated measure based on custom X-axis Scale

shyamcharan — Tue, 10 Mar 2015 01:29:40 GMT

Hi,

Sorry just a bit confusion on the X-Axis value(Usage) band.

When I select a step of 250 the x-axis shows values as 0,250,500,750, etc.

Now, When I have a value(amount or Cost) at 65 usage where does the data value will be shown, at a lower band value or upper band value? Is it at 0 or 250?

Regards,

Shyam.