topic How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ? in QlikView

How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ?

paulyeo11 — Thu, 23 Jun 2016 05:58:30 GMT

Hi All

My objective is to see sales increase by country.

My table 1 when click on Button 1 , Dimension = COMPANY. the report shown correctly.

2015 DISPLAY 6,090 AND 2016 DISPLAY 103,212

But when i change to dimension to SOURC by Click on Button 2. HOW TO MAKE 2015 DISPLAY 6,090 AND 2016 DISPLAY 103,212 , Now it display wrong value.

Paul

Re: How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ?

paulyeo11 — Thu, 23 Jun 2016 05:59:07 GMT

my QVW

Re: How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ?

tamilarasu — Thu, 23 Jun 2016 06:52:28 GMT

Paul,

I guess, the values are correct. If you change the dimension, the expression calculates sales for the particular dimension. Are you sure the values are wrong.? Are those companies are belongs to source TDSPG.

Re: How to make my Table Total amount display same value when my dimension change from COMPANY TO SOURCE ?

paulyeo11 — Thu, 23 Jun 2016 07:25:00 GMT

Hi Tamil

when i click on Button 1 , Table 1 Display LY Toal 6,090 and YTD 103,212. it is correct.

My question is when i press on Button 2 ,

So how to make Table 1 display LY Toal 6,090 and YTD 103,212,

Now it display 76,991 and YTD 110,109. Because it does not take into consideration of those sales increase customer.

it display all total sales include sales drop customer amount.

Paul