topic Re: Script/Expression Help Required in QlikView

Script/Expression Help Required

Mon, 30 Dec 2013 14:39:00 GMT

Hi,

I'm a beginner to Qlikview.

I'm trying to write an expression to calculate the annual cost differential (numerical and percentage), for every department.

Please find attached an example.

Any suggestions greatly appreciated.

Regards,

Andrea

Re: Script/Expression Help Required

Gysbert_Wassenaar — Mon, 30 Dec 2013 15:09:51 GMT

See attached qvw for two options.

Re: Script/Expression Help Required

Peter_Cammaert — Mon, 30 Dec 2013 15:37:08 GMT

A more dynamic version that uses expressions only (above() function) and matches your layout.

Best,

Peter

Re: Script/Expression Help Required

Mon, 30 Dec 2013 20:52:27 GMT

thank you so much for your help!

Re: Script/Expression Help Required

Mon, 30 Dec 2013 20:52:42 GMT

thank you so much for your help!

Re: Script/Expression Help Required

sebastiandperei — Tue, 31 Dec 2013 03:01:47 GMT

Mark as answered if it was right for you!

Re: Script/Expression Help Required

Sun, 05 Jan 2014 14:01:06 GMT

Hi! How can I create a dashboard chart to show the annual cost differential (percentage)?
Thanking you in advance for your help!

Re: Script/Expression Help Required

Peter_Cammaert — Mon, 06 Jan 2014 08:01:05 GMT

Well basically there are two methods here:

Either open Gysbert's or my example model, select the object of your preference, select Edit->Copy from the menu bar, move to your opened QVW, select Edit->Paste. Rightmouseclick the new object, select Properties and change all field names (Dimensions & Expressions tabs) into proper ones, i.e. the corresponding ones in your model.
Or create a new dashboard object by selecting Object->New Sheet Object->Chart... from the file menu in your new model, selecting an object type (e.g. Straight Table) and adding Dimensions & Expressions like the ones that were used in the examples.

All example charts contain expressions for both amount & percentage presentations of the Annual Cost Difference. Just copy the ones you like.

Good luck,

Peter

Re: Re: Script/Expression Help Required

Mon, 06 Jan 2014 20:36:14 GMT

Hi! Thank you for your help!

I try to use expressions only(above() funtion) to calculate the difference of costs from 11/2011 to 03/2012 and from 11/2012 to 03/2013, but it doesnt work. Can you can a take a look to the example attached, please?

I really appreciate any help you can provide!