topic Re: data not match straight table and pivot table in QlikView

data not match straight table and pivot table

Anonymous — Thu, 04 Apr 2013 08:25:17 GMT

i change the expression beacause of change the negative value to zero so i write below script to convert negative value to positive so its again showing mismatch total with same expression. in straight table total showing 440 its correct but in pivot its showing the same 338.15 after change the negative value to zero

if((sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))<0,0,

sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID)))

Re: data not match straight table and pivot table

sushil353 — Thu, 04 Apr 2013 11:41:34 GMT

Hi,

Please explain your scenario a bit more..

it is insufficient information to comment.

HTH

Sushil

Re: data not match straight table and pivot table

neha_shirsath — Thu, 04 Apr 2013 12:23:30 GMT

Hi mohammad faizan,

Can you attach some sample data, so that it will be more clear.

Regards,

Neha

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 06:22:16 GMT

please guys check the snapshot and tell me where is the problem the total not match in two different table with same no. of records

Re: data not match straight table and pivot table

neha_shirsath — Fri, 05 Apr 2013 06:45:32 GMT

Hi Mohammad,

Have you check the both charts expressions?

and also check in excel if both tables values are same or not.

or else please post qvw.

Regards,

Neha

Re: data not match straight table and pivot table

kaushiknsolanki — Fri, 05 Apr 2013 06:47:20 GMT

Hi,

Try this expression.

Sum(Aggr(Your Expression),Opportunity_ID))

Regards,

Kaushik Solanki

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 06:48:24 GMT

hi neha,

both the chart expression is same only the different view is there means same expression with same data straight table total showing 398.150 and pivot showing 399.150 with same quarter Q1

Re: data not match straight table and pivot table

sushil353 — Fri, 05 Apr 2013 06:53:14 GMT

hi mohammad,

It is hard to analyze but still try to change the option of TOTAL MODE in expression tab.

Try different option like Expression Total or Sum of rows.

HTH

Sushil

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 07:03:52 GMT

thanks kaushik always your soluttion work i know, its work fine.

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 11:05:59 GMT

i change the expression beacause of change the negative value to zero so i write below script to convert negative value to positive so its again showing mismatch total with same expression.

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 11:08:01 GMT

i change the expression beacause of change the negative value to zero so i write below script to convert negative value to positive so its again showing mismatch total with same expression.

Re: data not match straight table and pivot table

prasad_dumbre — Fri, 05 Apr 2013 11:13:16 GMT

As Mr. Sushil said, make sure you have Expression Total or Sum of rows in both charts . . .
Keep the same thing is both.

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 11:15:53 GMT

i change the expression beacause of changing the negative value to zero in expression so i write below script to convert negative value to zero so its again showing mismatch total with same expression. in straight table total showing 440 its correct but in pivot its showing the same 338.15 after change the negative value to zero

Re: data not match straight table and pivot table

Anonymous — Fri, 05 Apr 2013 11:45:29 GMT

guys i got the solution thanks for your helpful reply,i write a solution please check if you have any other wyt so please let me know.

sum

(Aggr( if(( (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual)))<0,0,

sum(Aggr (sum({<type={"opportunity"}>}hc_saving)-sum({<Opportunity_ID={"*"} >}EFF_Actual),Opportunity_ID))),Opportunity_ID))