QlikView Help

[#1]

Hi Qlik Gurus,

I need your help once again.

I neet to create a total box based on the separate excel sheet, in already created dashboard. There are two common fields Product and Monitoring Activities. Since these two fields are common, however the data is different, and it interviens with graphs already created. If I rename the fileds the total would not change when filtering on product or Monitoring Activity.

I need to be able to filter in a way that number in the total box changes, but not another way around.

This is what i should have in the graph and this should not change when I load that addidtional excel

This is what happens when I load the table with the same field names

Thank you-

[arasantorule]

Hi Nina,

Can you please provide more detail on this. Please attach the QVW file if possible with error and expected output.

whether the new excel sheet should have an association to previously loaded data?

If so, which filed needs to be the key?

If product is the key, rename the Monitoring activities to a different name. Now the link will be fine.

Also renamed filed (monitoring activities) can also be used for filtering without any issues.

Thanks.

[#3]

Hi Arasantorule,

i cannot attch the dashboard. The new excel should have association to the old on only on the filed , however i do not want it to impact the graph results. I only want this excle to be populated in the total box. And I want this total number to change once i select on the filters with common filds, which are product and Monitoring Activity.

But not other way around.

Tahnk you-

[#4]

  Second table used, that is effecting the original graphs. Please let me know if you have questions 

Products	Advisory Boards	Field Coaching Guides	Field Ride-Alongs - MSLs	Field Ride-Alongs - Sales	Product Theater	Speaker Programs
Product 1	5	7	9	4	1	5
Product 2	8	3	2	9	15	10
Product 3	9	5	3	11	2	13
Product 4	12	10	8	14	5	3
Product 5	4	11	10	2	7	3