How to fetch individual Budget value

[Raju_123]

Hi Experts,

I need your help to suggest for the below data fetching issue.

I have excel sheets with same column names and difference in Budget .when loading the tables the columns are auto concatenating and giving me the summed value in UI .I want to show the individual values from each sheet How to achieve this.

Example: 1st sheet my whole value is 5500 

                     2nd sheet the whole value is 7500

In qlik it is showing 13000.I want to show 5500 and 7500 

[Prashant_Naik]

Hi,

You can do is create a flag in both the table like

table_1:

load *,

1 as sheetflag

from sheet1;

concatenate

load *,

2 as sheetflag

from sheet2;

and if you dont want the tables to get concatenated then you can use Noconcatenate functionality of considering both the tables different. script would go like this.

table_1:

load * from sheet1;

Noconcatenate

table_2:

load * from sheet2;

Regards,

Prashant

[Raju_123]

Hi Prashant,

Thank you very much for your reply.I am using cross table in my load script because my excel is in pivot format and contains Actual and Unpaid sales over month.

[Prashant_Naik]

Hi,

can you provide some dummy data so i can help you out with it.

Regards,

Prashant

[Raju_123]

Hi Prashant,

Please find attached sample excel. My requirement is to load all the sheets from the excel and display the budget values based on the project. The data has to choose based on the project name of the sheet(sheet name)

[Usama]

Hi,

In the attached data which value you are assuming(Total expenditure, Budgeted Value) which you want to display in UI?

Thanks