topic Re: Chart Expression for Follow Up date analysis in QlikView

Chart Expression for Follow Up date analysis

Thu, 16 Jan 2014 10:39:46 GMT

Hi,

I am currently building a dashboard which will include analysis to follow up opportunities. Ideally I want to show in a chart if an opportunity is overdue, ie follow up date =today, <=today, >today (overdue).

Can anyone advise of the best expression to calculate this?

Thank you.

Re: Chart Expression for Follow Up date analysis

Thu, 16 Jan 2014 10:42:44 GMT

try this

if(Date<=today(),oppertunity)

Re: Chart Expression for Follow Up date analysis

datanibbler — Thu, 16 Jan 2014 10:43:44 GMT

Hi,

try doing it as you say it, with an IF-condition.

=> What do you want to happen if an opportunity is overdue? Only the fact? -> In that case, you don't need a real chart, a textbox that can change in colour and text would be enough for that.

HTH

Best regards,

DataNibbler

Re: Chart Expression for Follow Up date analysis

Thu, 16 Jan 2014 11:06:30 GMT

Hi,

If u want to highlight the oppurtunities in a chart u can use if condition in dimension/Expression background like follows:

If(Date<=today(),green(), if(Date>today(),red()))

Please post sample QVW.

Hope this helps.

-Shruti