topic Re: how to split reference line? in QlikView

how to split reference line?

Wed, 14 Jan 2015 09:20:53 GMT

Hi everyone,

I'm new to qlikview and dealing with something about the sea port and have two questions.

Now I have the stacked bar chart and want to set reference line for different time period. The ideal effect should be like this:

I tried out editing condition of reference line but didn't work. The reference line is always displayed as a long line and I can not split it to segments. The values of each reference line segment are not fixed. A input box will also be added to type the 4 values.

Any ideas? Thank you very much!!

(I am using personal edition so please better provide pictures instead of qvw files)

Min

Re: how to split reference line?

Wed, 14 Jan 2015 09:27:57 GMT

Hi,

Your screenshot doesn't open it seems.could you please repost it?

Thanks

Re: how to split reference line?

Wed, 14 Jan 2015 09:30:34 GMT

Sorry Sudha, please view the attachment. Thank you.

Re: how to split reference line?

isorinrusu — Wed, 14 Jan 2015 09:40:18 GMT

Hi Lyu,

What you could do is to use a combinated chart (lines and bars) and put the reference line as an expression, drawn as a line. For this, you have to create values in your data for it.

Regards,

Sorin.

Re: how to split reference line?

simondachstr — Wed, 14 Jan 2015 09:46:00 GMT

That will not work because reference lines are non-dimensional calculated values which are displayed in the chart (mostly on the y-axis). Non-dimensional implies that they can't reference the actual dimension of the chart. I suggest trying a workaround with a ComboChart e.g. displaying a bar chart as reference lines and make the bars transparent so they look like lines.

Re: how to split reference line?

Wed, 14 Jan 2015 10:02:13 GMT

Thanks for your advice.

However if I create value for it in the data, is it mean i have to change the value in the data file and reload if i need to change the critical value? Actually the values changes everyday.

Re: how to split reference line?

Wed, 14 Jan 2015 10:05:53 GMT

Thanks for your advice. Another question is how can I change the values? Do you have any suggestions for me to make the critical values as four variables? So that i can change it in the qlikview interface instead of in the data file.

Re: how to split reference line?

Wed, 14 Jan 2015 10:09:02 GMT

Hi,

As per John's post i have tried this.

Re: how to split reference line?

Wed, 14 Jan 2015 10:11:10 GMT

Sorry,The link is given below

http://www.qlikcommunity.com/thread/64174

Re: how to split reference line?

Thu, 15 Jan 2015 01:12:01 GMT

Thank you Sudha, your suggestion is very helpful.

But i have two problems when apply it to my case. One is I choose combo chart, but combo chart doesn't support stacked bar chart.

Another problem is I set the x axis dimension to be continuous, but in match function match(FieldName, 'FieldValue1', 'FieldValue2',....) the field value seems to be discrete, how to set the field value to be an interval of x axis?

Thanks a lot.

Min

Re: how to split reference line?

simondachstr — Thu, 15 Jan 2015 09:43:51 GMT

Use input boxes for manual input or sliders for a more interactive solution.

Re: how to split reference line?

Thu, 22 Jan 2015 01:03:54 GMT

Thank you very much Sudha,

Finally it works by applying pick(intervalmatch()) function.

Regards,

Min

Re: how to split reference line?

agni_gold — Mon, 10 Apr 2017 07:38:09 GMT

this link is not working is there way to open this link , or you have any qvw file which is attched to it ?