Help a newbie write chart expressions!

[#1]

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

[kouroshkarimi]

Could you please attach a sample data set?

[#3]

Attached as per request. Thanks

[kouroshkarimi · Accepted solution]

See attached, hope it helps.

[#5]

Thanks kouroshkarimi  - that is exactly the script I was looking for. I added it to my expressions - without changing the joins - and it appears to work very well. Can you explain to me the importance of changing the join?