topic Bar Chart for Daily Budget in QlikView

Bar Chart for Daily Budget

Mon, 22 Jul 2013 12:40:11 GMT

Hi All

I have a FACT or TRANSACTION table in which my Dailys Sales and Monthly Budget is stored.

I would like two bar charts (Sales vs Budget) but where the x-Axis dimension is daily.

Problem is my budget date is only 1st of each month as we set it monthly not daily hence I can Full Accumulate Sales but the budget only appears once.

I would like to calc an ave daily budget, i.e.: BudgetValue/WorkDays and then Full Accumulate this? Any ideas please? See attached current Chart.

Re: Bar Chart for Daily Budget

er_mohit — Mon, 22 Jul 2013 12:43:13 GMT

I think in expression tab for that expression tick on relative and full accumulation with your simple expression

Re: Bar Chart for Daily Budget

Mon, 22 Jul 2013 12:53:50 GMT

Tried but it does not accumulate.

Here is the expression now:

Sum({<Type={'BR'},Date={'>=$(vFYPeriod)<$(vToday)'}>} Value)/30

//the result is $2,3mil but when relative and full accumulate the expression it looks like this (attached)

Re: Bar Chart for Daily Budget

kaushiknsolanki — Mon, 22 Jul 2013 12:56:59 GMT

Hi,

Why dont you divide your budget by no of days in month to get daily budget, then you can use the accumulation to get the values.

Regards,

Kaushik Solanki