topic Re: Unexpected expression result in Pivot Table in QlikView

Unexpected expression result in Pivot Table

nagarjuna_kotha — Fri, 08 May 2015 04:43:52 GMT

Hi i have a one requirement using Pivot table.In that i m facing one issue i m not getting TOTAl on one colum,what should i do ,tell me some valid solutions.i m sharing expressions cheak it where i m doing wrong,PLzzz Give ASAP

=(Num(Sum(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> Aggr(

IF( Window_Id=2,

sum({<RTESACall_247={'Within4HR'},Tier={'Metro','Tier 2','Tier 3 and Above','Undefined'}>}TotalRTCall),

)

, REGIONNAME,

BRANCHNAME,

DIVISIONNAME,

DEALERNAME,

Tier

))

,vFWNumberFormat

))/(Num(

SUM(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> TotalRTCall)

,vFWNumberFormat

))

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','90',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','85',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','80')))& ' '& '%'

//=if(not IsNull(DIVISIONNAME),$(vCost))

(Num(Sum(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> Aggr(

IF(Window_Id=2,

sum({<TATESACall_247={'Within48HR'},Tier={'Metro','Tier 2','Tier 3 and Above','Undefined'} >}TotalDTCall),

)

REGIONNAME,

BRANCHNAME,

DEALERNAME,

DIVISIONNAME,

Tier

)),vFWNumberFormat

))/(Num(

SUM(Total<REGIONNAME,BRANCHNAME,DEALERNAME,DIVISIONNAME> TotalCall)

,vFWNumberFormat

))

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','80',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','75',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','70')))& ' '& '%'

=Count({<STATUS_ID= {1014,1015,2061},CALL_CATEGORY={'PMS'}

>}DISTINCT(TICKET_ID))/Count({<CALL_CATEGORY={'PMS'}>}DISTINCT(TICKET_ID))

= if(Count(DIVISIONNAME)>0 and DealerCategory='A','98',

if(Count(DIVISIONNAME)>0 and DealerCategory='B','95',

if(Count(DIVISIONNAME)>0 and DealerCategory='C','93')))& ' '& '%'

=sum({<Division={'50','51','52','53','54','55','56','57'}>}BillAmount)

=if(DealerCategory='A',150000,

if(DealerCategory='B',100000,

if(DealerCategory='C',75000))

)

=sum(PAYOUT_RATE)

10.

Bonus% :

=if(DealerCategory='A' and Column(1)>='90%' and Column(3)>='80%' and Column(5)>='98%' and Column(7)>='150000',10,

if(DealerCategory='B' and Column(1)>='85%' and Column(3)>='75%' and Column(5)>='95%' and Column(7)>='100000',5,

if(DealerCategory='C' and Column(1)>='80%' and Column(3)>='70%' and Column(5)>='93%' and Column(7)>='75000',1,0)))&'%'

Bonus :

=Num((sum(PAYOUT_RATE))*Column(10))

Urgent>>>>>>>>>>>>>>>>>>>>>>.

Thanks in Advance

Re: Its Urgent!!!!!

tamilarasu — Fri, 08 May 2015 04:55:57 GMT

Nagarjuna: Is it possible to upload the file.?

Re: Its Urgent!!!!!

nagarjuna_kotha — Fri, 08 May 2015 05:08:24 GMT

Re: Unexpected expression result in Pivot Table

PrashantSangle — Fri, 08 May 2015 05:16:57 GMT

Hi,

What do you expect in Total Column??

It is sum or Avg of column

Use appropriate function in expression

try like

sum(

if(DealerCategory='A' and Column(1)>='90%' and Column(3)>='80%' and Column(5)>='98%' and Column(7)>='150000',10,

if(DealerCategory='B' and Column(1)>='85%' and Column(3)>='75%' and Column(5)>='95%' and Column(7)>='100000',5,

if(DealerCategory='C' and Column(1)>='80%' and Column(3)>='70%' and Column(5)>='93%' and Column(7)>='75000',1,0)))

)&'%'

Regards

Re: Unexpected expression result in Pivot Table

ToniKautto — Fri, 08 May 2015 05:19:16 GMT

I have changed the subject of this thread to better describe your question. There is no urgency parameter in the community, so to get best possible attention and feedback it is important to provide a accurate subject and appropriate level of details to enable community member to understand your problem and scenario.

- A chart is calculated based on the fields used in dimensions and expressions.

- The required data from these fields will be extracted to enable the aggregation

- The relation of the fields in your data model determine how the data in the fields will be joined together

- A problem is typically defined by a observed result and a expected result

Please clarify who you think we are supposed to understand your data model, chart setup, expected result and observed result based on a list of expressions if you are not able to provide a sample file?