topic Re: Keeping an axis reference line fixed in QlikView

Keeping an axis reference line fixed

Fri, 03 May 2013 20:20:47 GMT

I have a listbox with the three categories A, B and C, a customer table with customers who either belong to category A, B, or C, and a table with sales that correspond to each customer. I have a scatter graph with sales on the x axis and another value for the y axis. I would like a reference line to be locked for the median sales values for the x axis for the category A, B or C selected. and not to change when the user subselects a customer which belongs to one of the categories.

Namely, I need the median of the sales values for all of the entries that correspond to category A to remain fixed, even though the user select a a subset of customers for that category.

Re: Keeping an axis reference line fixed

MayilVahanan — Fri, 03 May 2013 21:27:32 GMT

Add reference lines in the presentation tab.

Add trends line which is in the expression tab.

Hope it helps.

Re: Keeping an axis reference line fixed

sibin_jacob — Sat, 04 May 2013 10:57:11 GMT

Hi,

First add a reference line in the presenation tab.

For that reference line, write a set expression excluding Customer_Name.

then go to to Axis Tab , check the Center on property of X-Axis and add the same set expression.

Thanks,

Sibin Jacob. C