Can i add the data in the report level in Qliksense?

[Anonymous]

Hello Experts,

Can i add the data in the report level in Qliksense?

Example : I have to compare the data Actual Vs Forecast.

I this example  Actual data is coming from Database and I need to Enter Forecast data in report level. Based on that i can compare the data. Is it possible,

Thanks in advance

Regards,

Kiran

[shraddha_g]

Does Report level mean App level or Sheet level?

[rohitk1609]

Hi Kiran,

Lets say your Actual Data is coming from Data base and you have a sheet where your forecast data is there , So yes you can do this ,What you need to do create a local connection in scripting part and import that foretast sheet and go to UI and compare it.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

[Anonymous]

It is not clear what the "report level" means here.  "Report" is not a technical word in the Qlik Sense - it could be an application a sheet, and object...
To add data which are not in the database - you can keep Forecast data in a file, e.g. Excel, and use it as an additional data source.

[Anonymous]

Hello ,

It is in Sheet Level,

here iam adding data from database, some data is there for forecast,( ex: jan to aug), it is displaying the values and i dont have forecast values for sep, oct ,nov , dec month data.

actually my question is can i add data in sheet level? is it possible?

[Anonymous]

Data is always on the application level.  Of course you chose what you show on the objects which you put on the sheets.

[lakshmikandh]

Hi,

If you have transaction data at more granular like transaction level

i.e TranNo/DocumentNo | Itemcode | ItemVariant | Location | Date | Month | etc | etc | ActualValue | ActualQty

and you have your forecast at Month level for each of Location and Product in Excel

Then upload that excel values into app with same column name as like transaction data

Product | Location | ForecastValue | ForecastQty

Qlik sense will automatically form the synthetic key in the so that when you do visualizations with those field (ex) a table/ pivot table you will be able to compare the Actual vs Forecast against a common dimensions.

Hope this Helps you

Thanks,

Lakshmikandh