3 Replies Latest reply: Jan 21, 2015 10:19 PM by Yilin Xie RSS

    Max value for each series in a line graph

      Hi, I am a newbie in using Qlikview and had just picked up a couple of days ago.

      I was wondering if we can use Qlikview to automatically identify the maximum values for each series of the graph.

      the image i have in my mind is something like...

       

      image.jpg

      Where the max value for each series is identified and a symbol is added to highlight the max value.

       

      I tried replicating this graph by using

      Dimensions: "Date" and "Brand"

      Expressions: "TextCount(Brand)" and "If(TextCount(Brand) =Max(TOTAL <Brand> aggr(TextCount(Brand),Date,Brand)),TextCount(Brand))"

       

      Not sure what am i doing wrong here.

       

      I have attached a sample of the data source for testing.

       

      Thanks..