topic Re: Budget Excel File Issue in QlikView

Budget Excel File Issue

azmeerrehan — Sat, 15 Jul 2017 14:55:19 GMT

I have a Budget file coming from Excel. The BUdget File is at a certain level and has Year,Month,Dim1,Dim2,Dollars.

The qvw has a MAster Calendar with Year and Month, has a Dimension Table and a Fact Table.

The LInk between Master Calendar and Dimension Table is

Year&'|'&Month as %DateKey

Link between Dimension Table and Fact Table is Fact_ID

The budget is for the whole year of 2017 but the but the dimension table has Data up to 07/2017.

I linked the Budget Excel file to the Dimesnion table as

Dim1&'|'&Dim2&'|'&Year&'|'&Month as Bud_Key

The Issue is that since the Dimension table has only data up to July the Budget data also shows up to July and rest goes under blank. See Attached OUtput file.

I would like see he Budget populated for All months of 2017 up to Dec

So now my data model looks like the attached file .

Re: Budget Excel File Issue

saimahasan — Sun, 16 Jul 2017 06:08:56 GMT

Can you try linking your excel and Dimension table with just Year-Month?

Re: Budget Excel File Issue

saimahasan — Sun, 16 Jul 2017 06:10:07 GMT

And if you will take the amount from your fact table which is only till July then definitely you wont be able to see the entire years budget . Rather if you desire to see the Budget also alongwith the amount then you will get it for the entire year.

Re: Budget Excel File Issue

azmeerrehan — Sun, 16 Jul 2017 06:20:07 GMT

Yes tried that also didnt work

Re: Budget Excel File Issue

azmeerrehan — Sun, 16 Jul 2017 06:21:20 GMT

What do u mean by this?