Help on line chart

[#1]

Hi,

i am trying to format the line graph in such a way that the value on data points to be shown as vertical and in downward direction. in my chart it is showing in upward direction. but if i have two columns having near about same value then it gets overlapped and the values are not visible properly. i would like to show both lines with values visible at the same time. Can somebody help me with this.

i would like to have values on one line to be in upward direction and the second line to be in downward direction. also is it possible to have line style such a way that at each value point a dot is shown.

it would also be appreciated if somebody could help me in giving some example for adjusting the scale when using drilldown group as dimension. i have a dimension group year,month,date. according to the dimension field the scale should be adjusted in such a way that static max = max value of expression for that dimension field + 50. static min should not start with 0 instead it should be min value of expression for that dimension field + 20.

[IAMDV]

Hi,

Have you tried to adjust the chart by pressing CTRL + SHIFT? Where you can move the objects within the chart. And if you wanted to control the Static Min and Static Max based on Dimension Group then you need to do following steps.

1. Create a variable

     Variable Name          :     vCurrentDim

     Variable Definition     :   =GetCurrentField(MyDimensionGroup)

2. Now you need to use Aggr() function calculate the Min & Max values based on your Current Dimension

     Static Min  Expression     :     Min({1} Aggr(YourExpression, $(vCurrentDim))) - 20

     *Not sure if you want Min value + 20. I think you meant Min Value - 20 instead. It doesn't make sense to use      (+20) because this will hide the Min Value for that      Dimension.

     Static Max Expression     :     Max({1} Aggr(YourExpression, $(vCurrentDim))) + 50

*Note : I have used {1} so that you ignore the current selection and calculate the Min & Max accross full set.

I hope this makes sense. If you need futher help then please post sample App.

Good luck! 

Cheers,

DV

www.QlikShare.com

[#3]

Hi Deepaak,

thanks for your response.

Regarding setting the max and min limits for access, i tried your suggestion, but in the variable definition it is not recognition my dimension group. I have a drill down group called TradeCalendar having Trades_Year and Trades_Month as dimension fields. I tried variable defintion as

mydimfield = GetCurrentField(TradeCalendar), buts it not working. If i try giving Trades_Month or Trades_Year directly in the aggr function then it works. can you please post a sample showing to aggr over dimension group.

Regarding my first issue of 2 line graphs overlapping and hence the values on data points are not displayed properly. I am attaching the snapshot for the same. Please let me know if you have any suggestion for that. Since the values of the both the lines are near about same, it is causing an issue. I want to display values for both the lines.

[IAMDV]

Hi,

It will be good if you post your application with sample data. Meanwhile here are my thoughts...

1. If the Aggr() function works without GetCurrentField then the issue is with the variable. Have you included "= GetCurrentField(TradeCalendar)"? I mean you need the "=" at the beginning for this to work. So please make sure that you have "=" and then GetCurrentField(TradeCalendar).

2.I think you need to increase size of your chart or limit the number of visible lables. Probably show one of them on "Text on Axis" and another one "Value on Data Points". Because QlikView does not provide intelligent spacing(margin) between the lables. Hopefully they will integrate in future versions. Also, try the Logirthim scale (Log Scale) check box under Axis Tab.

Hope this makes sense!

Cheers,

DV

www.QlikShare.com

[IAMDV]

Have you got chance to look at what I've suggested?

Thanks,

DV

[#6]

Hi Deepak,

     Regarding getting the currentfield of the dimension group, i tried making a sample application as suggested. but not sure exactly where to assign the value of the variable. In the attached sample, i have assigned the variable on chart activate event and hence it shows the current dimension whenever the chart is activated. It is not showing on change of the dimension. Please have a look at the attached sample and let me know where i should assignt the value to the variable.

[IAMDV · Accepted solution]

Hi,

Please see the attached file. Check the variable and the Min & Max Axes expressions.

I hope this is what you need…

Cheers,

DV

www.QlikShare.com

[#8]

Thanks Deepak, its working now

[IAMDV]

You are welcome