Cross Functional QlikView

[jaspal_icon]

Hi All,

I am looking for the solution for Cross Functional in big organisation. Data from Sales (Multi Dimensional- Fact Tables), Marketing(Multi Dimensional- Fact Tables), Finance(Multi Dimensional- Fact Tables) etc.

Now what approach we should follow for this kind of requirement. If Create separate document for separate department then how to integrate as one and how it will navigate so that it looks like one single solution?

Please share your expereince and best approach for same.

Thanks in advance

Best Regards

Jaspal Singh

[deepakk]

Hi Jaspal,

I would suggest you take one module at time. Make a different application for each module.

Once you develop these application you will be in a position to know in and out for their business, their data, table structure etc.

And hence you will be able to suggest Dashboard which will contain important KPI from all these modules in another different qvw application.

Since these KPI will be at summary level, you Dashboard will not be bulky. And through these Dashboard application you will be able to navigate to other module (by calling qvw files).

Deepak

[jaspal_icon]

Hi Deepak,

Thanks for giving time to reply.

Your answer is helpful, but I am looking for more technical aspect which I might be dont know. For exmple: One Sale dashboard and from there I want to go on Finance dashboard, both are separate document, Now I navigate using some trigger and open that document. but how I will use my selected values on that document. like in Dot net web application we had the session to share in which we can store our values and pass to next web page. Do we have anythign like that.

anything else you would like to recommend then most welcome.

Regards

Jaspal singh

[#4]

Hi Jaspal,

You dont need to create seperate qvw files for each functional module.

You should create a single qvw file with all the data and use a linked table to link all the functional module .

I  had worked on a scenario where i had to combine data from sales, inventory, quality, services etc into a single dashboard.

I used a link table to connect all the different functional modules. I should mention that you shud have/create a common key/link between all of the modules which u can feed into the linked table and then coneect the modules thru the linked table.

Hope that helps.

BR

Abhinava.

[deepakk]

Hi Jaspal,

There are options of transfer state from one application to another. The technical query which you have is manageable.

But there are certian question you need to ask before you seprate the application.

Do they need to navigate from Sales Dashboard to Finance ?

Becoz sales Dasboard will have a different set of KPI lke YTD v LYTD vs Budget where as your finance module will

Have Ratio Analysis, Cash Flow , Balance sheet etc.

You can combine module where will there is constant link like Sales and inventory.

Over all it depends on your data volume too and complexity of Logic applied on the reports.

Deepak

[jaspal_icon]

Thanks Abhinava, And Deepak for your given time to reply this.

First thing, I dont want a single document having all dimension and Fact table from all functional module,

As the Document will got heavy and then any selection will take time to give result.

I want to combine just on Top level(using some compiled aggregation table) then want to drill down. I clear this by one example:-

Suppose I have some Gauges which combines value from Sales, Inventory and Finance.

Now when I click on any gauges it goes to that Financial , Sale or Inventroy Document.

                                         1. Dashboard.QVW(Sales, Inventory, Finance, Masketing)

                                                                        ||

                                        2. Sales.QVW    3. Marketing.QVW  4. Finance.QVW

Now lets I have selected the Year 2012 and Country: India in 1 Dashboard, and then click on one Gauge will take me to Sales.QVW Now I want that selections here. How you achieve this? any possibility over here?

Any suggestion Why should I make one QVW file as ABHINAVA suggested.

Because when we are going to develop for some cross functional then there must be a huge number of KPI and reports for each and every department. then how feasible to show 70-80 Sheet tabs?

Share some experince where you have done like this and in better way withour loosing the performance and capability of Qlikview.

Thanks

Best Regards

Jaspal Sing

[deepakk · Accepted solution]

HI Jaspal,

Try out the attach application.  In Test2.qvw , I have created a button which calls test1.qvw.

The selection which we make in test2 gets transfered to test1.

Make sure you copy both the files in same folder or provide the  path of test1(on the button event).

Deepak

[jaspal_icon]

Thanks Deepak, and I Appreciate your dedication for help.

This is exactly what I am looking for; but something wrong here, that It does not work in Loop, ex: put same button on test1.qvw which you put on Test2.qvw. Now see that if you change any selection on test1.qvw then it do not reflect on test2.qvw.

It works first time. from test2 to test1 .

second time if you navigate from one document to another then it do not work, what I observe.

----

But in Access point behaviour is different. test1 can not send anything to test2, but test2 selections went in to test1., Seems like the first document behave like a parent, who can give command to child but again child can not send back the command.

[deepakk]

HI Jaspal,

It doesn't work if the file is already open.

You can try out the new test2 and test1 file attached.

Deepak