topic Re: Bar chart in QlikView

Bar chart

Anonymous — Fri, 10 Oct 2014 19:36:16 GMT

Hi All,

I need to show the bar chart of the sum of Projection amount month wise on below criteria

If the year is 2013 then use the projection 'OP' to count the Amount

If the year is >=2014 then use the projection 'B Q4' if not exits then use B Q3, if not then B Q2, if not then B Q1 to count the Amount

Attaching the data sheet. Please let me know if questions.

Thanks for all help.

Regards,

Ankit

Anonymous — Fri, 10 Oct 2014 20:16:55 GMT

Any answers please?

Fri, 10 Oct 2014 20:37:21 GMT

Try this in your expression:

if( YRMON like '2013*', count({< Projections = {'OP'}>} Amount), if(YRMON like '2014*', count({< Projections = {'B Q*'}>} Amount)))

ecolomer — Fri, 10 Oct 2014 20:44:16 GMT

Here you have your data, but wich is the question exactly ?? (sorry because my english is not good)

MarcoWedel — Sat, 11 Oct 2014 00:38:36 GMT

maybe this thread helps also:

regards

Marco