topic Re: Help with Scripting in QlikView

Help with Scripting

Anonymous — Thu, 20 Sep 2012 14:47:22 GMT

Hi All, I have a following requiremen Any help on this is greatly appreciated and not getting ideas on how to do the scripting. in the below sample application i have a line chart with dimensions Style & Display Year and expression Sum(Sales). For each style the display year would be different but the requirement is that the trending of each style should start at the same point and end at a data point where its history is finished.

for example Style RUSSA1 started in 2010 and ends at 2012 . But in the out chart i should get like it should start in year zero and end at year 2.

and another example: for Style TVB which started in 2007 and ending at 2012. So i output chart it should start at year 0 and end at year 4.

To give you a clear picture i have attched a screen shot how the output chart should look like.

Thanks in advance for your help.

Re: Help with Scripting

Anonymous — Thu, 20 Sep 2012 15:52:37 GMT

Any help on this...

Re: Help with Scripting

Anonymous — Thu, 20 Sep 2012 18:10:34 GMT

Any help on this.

Re: Help with Scripting

whiteline — Fri, 21 Sep 2012 09:36:42 GMT

Hi.

It seems, you didn't provide your script.

Re: Help with Scripting

Anonymous — Fri, 21 Sep 2012 12:49:22 GMT

Hi Whiteline Thank you for your response. Sorry i did not give the subject right. I am unable to get to the approach itself on how i can change the year in the chart so that i can start scripting on that.

Re: Help with Scripting

Fri, 21 Sep 2012 14:22:06 GMT

Please see the attached QV application

Regards

Mhatim

Re: Help with Scripting

Anonymous — Fri, 21 Sep 2012 17:12:24 GMT

Hi Mhatim thank you for your help on this . the data present in application is very limited data. But i have almost 1000 Styles like that. In thank case how can we achieve that. Thanks in Advance.

Re: Help with Scripting

Anonymous — Mon, 24 Sep 2012 21:06:31 GMT

not sure if there was a way in Qlikview this issue we created a field in our database by that way we were able to achieve the solution.