topic Actual vs Budget in QlikView

Actual vs Budget

Anonymous — Thu, 29 Oct 2015 10:10:57 GMT

Initially I have two fact tables : Actual and budget

I consolidate them into one table TempVente as it's shown in the figure

I have for some Code site budget (for example Code site =10 ) but I didn't have actual , how can I make in this case code site in grey color in filter

The same case for datetime Sometimes I have budget but not actual , specilaaly for dates in the future

In other words , how can I all my filters attached to the measure actual and not to budget ?

Any help would be the most appreciated

Re: Actual vs Budget

marcus_sommer — Thu, 29 Oct 2015 10:15:28 GMT

I think you will need to create these missing data: How to populate a sparsely populated field.

- Marcus

Re: Actual vs Budget

Anonymous — Thu, 29 Oct 2015 10:29:31 GMT

I didn't figure out the idea .

Re: Actual vs Budget

sathishkumar_go — Thu, 29 Oct 2015 10:35:04 GMT

Hi Jaweher,

While doing the Actual and Budget data concatenate with one table you have to be very careful.

Take the data which don't have actual, those data's make it "0" as actual and concatenate with the "TempVente" table.

-Sathish

Re: Actual vs Budget

marcus_sommer — Thu, 29 Oct 2015 11:00:57 GMT

It's a complex and difficult topic and you won't get a quick solution then probably you will need bigger adjustments to your data-model. In some cases it's enough to use the implicit power of the qv color-patterns (grey), see: Finding NULL but is this isn't enough you need to create your missing data then only real data could be showed within qv.

See further here Re: Budget Achievement. to get more ideas how to could work on it.

- Marcus

Re: Actual vs Budget

Anonymous — Thu, 29 Oct 2015 12:30:39 GMT

I still do not figure out , I am a newbie with qlikview

Re: Actual vs Budget

marcus_sommer — Thu, 29 Oct 2015 13:00:49 GMT

I'm sorry but at the moment I could only recommend to read all the provided postings and their included links carefully then it's more complicated as it could be solved here with a few answers. It could be that you need external help from a qlikview partner for this task.

- Marcus