topic Re: Chart Help in QlikView

Chart Help

Anonymous — Fri, 03 Mar 2017 15:21:30 GMT

Hello-

I have a chart (posted below) that measures timeOUT as the Dimension and =CurrentTotal as the expression

What I want to be able to do is only show the red line (which is predictive) when the blue line (which is actual sales) ends, or after the max timeOUT.

Can anyone tell me how this would be able to be done?

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 15:25:16 GMT

Is the red line built using an expression?

Re: Chart Help

Anonymous — Fri, 03 Mar 2017 15:27:51 GMT

Yes, the expression is using two variables:

vPredictiveM =LINEST_M(CurrentTotal, timeOUT)

vPredictiveB =Max(CurrentTotal)-(Linest_M(CurrentTotal, timeOUT)*Max(timeOUT))

And the line expression is:

only({1}$(=vPredictiveM)*timeOUT)+$(=vPredictiveB)

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 15:32:19 GMT

May be you need to do this

If(Column(1) = 0, Only({1}$(=vPredictiveM)*timeOUT)+$(=vPredictiveB))

Here I am assuming that Blue line is your 1st expression and Red line is your second expression

Re: Chart Help

Anonymous — Fri, 03 Mar 2017 15:38:34 GMT

the blue line is my first line and the red line isnt 2nd, however when I do the above recommendation the red line disappears.

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 15:40:38 GMT

How about this:

If(Column(1) > 0, Null(), Only({1}$(=vPredictiveM)*timeOUT)+$(=vPredictiveB))

Would you be able to share a sample if this still doesn't work?

Re: Chart Help

Anonymous — Fri, 03 Mar 2017 15:43:22 GMT

Unfortunately i can't share a sample, however is there just a way to do this in the line shading? Like the background color or line style?

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 15:46:21 GMT

I guess it will run into similar issues... but I would try something like this in background color for the red line

If(Column(1) = 0, White(), LightRed())

Now this will again run into the same issues where it is unable to detect Column(1) value. Can you convert your chart into a straight table and share a screenshot?

Re: Chart Help

Anonymous — Fri, 03 Mar 2017 15:59:00 GMT

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 16:03:44 GMT

Try this

If(Len(Trim([Current Game])) = 0, Only({1}$(=vPredictiveM)*timeOUT)+$(=vPredictiveB))

or for background color expression

If(Len(Trim([Current Game])) = 0, LightRed(), White())

Re: Chart Help

Anonymous — Fri, 03 Mar 2017 16:07:14 GMT

The background works, except there are blanks in the current game (shown above) so it shows a dashed line in the middle of the chart. Is there a way to use Max(timeOUt) so that it only shows when above the max?

Re: Chart Help

sunny_talwar — Fri, 03 Mar 2017 16:10:28 GMT

It will be rather difficult to suggest without looking at this... See if this links help you share a sample

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample