topic Re: Help a newbie write chart expressions! in QlikView

Help a newbie write chart expressions!

Mon, 13 Aug 2012 07:00:47 GMT

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

Re: Help a newbie write chart expressions!

kouroshkarimi — Mon, 13 Aug 2012 08:25:50 GMT

Could you please attach a sample data set?

Re: Help a newbie write chart expressions!

Mon, 13 Aug 2012 09:08:38 GMT

Attached as per request. Thanks

Re: Help a newbie write chart expressions!

kouroshkarimi — Mon, 13 Aug 2012 09:33:15 GMT

See attached, hope it helps.

Re: Help a newbie write chart expressions!

Mon, 13 Aug 2012 23:34:44 GMT

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?