4 Replies Latest reply: Aug 13, 2012 7:34 PM by Chris Tonna RSS

    Help a newbie write chart expressions!

      Hi All, I am a 2 week QV newbie and need some help. I have a simple reporting database. I have columns for Actual, Target and KPI (among others). I want to build a chart that displays for me the following:

       

      Actual & Target lines but only when the value in the KPI column = Net Profit

       

      I then want to do another graph the same (using the clone function) but I want to limit it to KPI=Total Revenue (as an example) the same way.

       

      How do I do it in Qlikview?

       

      Thanks in advance,

      Chris