Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

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

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

3 Replies
paulyeo11
Valued Contributor II

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

my QVW

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

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.

paulyeo11
Valued Contributor II

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

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

.