topic Sales vs Budget data in QlikView

Sales vs Budget data

vireshkolagimat — Tue, 13 Mar 2018 15:32:52 GMT

Hi All,

I am trying to show the sales vs Budget data but i am not getting the expected result.

Sales is captured on daily basis and budget is for entire month. I made the changes to the budget data to adjust day wise.

when i look the data by agency and salesman level, it looks good. But when i bring the Brand name, the data is not coming properly.

Budget is updated by agency and by brand.

Kindly help me to fix the issue.

Regards,

Viresh

YoussefBelloum — Tue, 13 Mar 2018 16:16:28 GMT

Hi,

on this table:

what is your exptected output on the Budget ??

vireshkolagimat — Tue, 13 Mar 2018 16:42:10 GMT

Hi, The output should come like below.

Thank you.

YoussefBelloum — Tue, 13 Mar 2018 16:52:39 GMT

Try to attach some rows from your table