topic pivot table bar chart values not matching in QlikView

pivot table bar chart values not matching

Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i have one issue pivot table expression and bar chart expression both are same but values are mis matching if we select in below 2016

please help me

thank in advance

Re: pivot table bar chart values not matching

sunny_talwar — Fri, 16 Dec 2016 13:24:38 GMT

You might need to do use Sum(Aggr(Expression, Dimensions)) in your pivot table to fix the sub-totals for the pivot table

Re: pivot table bar chart values not matching

Mon, 19 Dec 2016 04:22:50 GMT

hi stalwar1

in pivot table values are coming correct but bar chart values are going wrong

Re: pivot table bar chart values not matching

Anil_Babu_Samineni — Mon, 19 Dec 2016 06:56:39 GMT

Check this, I didn't any wrong value here. And, i assume for pivot you may need like below

Expression for Pivot

=Aggr(if(Sum(Aggr(SUm(RADat_DUE),RADat_Project,RADat_SubProject,RADat_LESSEE_ID,RADat_BILL_ID))

- sum(if(RR_Receipt_date<=Date(T_Date,'DD/MM/YYYY'), RR_RECEIPT_AMT))

<>0, Sum(Aggr(SUm(RADat_DUE),RADat_Project,RADat_SubProject,RADat_LESSEE_ID,RADat_BILL_ID))

- sum(if(RR_Receipt_date<=Date(T_Date,'DD/MM/YYYY'),RR_RECEIPT_AMT)),0)/Value, Dim1, Dim2,....)

Re: pivot table bar chart values not matching

adamdavi3s — Mon, 19 Dec 2016 07:34:32 GMT

This is because your pivot table is being limited by the dimension:

=if(RADat_INVOICE_DATE<=Date(T_Date,'DD/MM/YYYY'),Lesse)

Where as your bar chart is not.

If you simply change the dimension in your pivot table to be "Lesse" then this works:

I can't see any need to limit the values for 'Lesse' with the IF statement as the relevant values will be ex/included based on your expression and other calculated dimensions anyway

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

Re: pivot table bar chart values not matching

Mon, 19 Dec 2016 07:43:13 GMT

HI ANIL,

CAN YOU UPLOAD THE QVW

Re: pivot table bar chart values not matching

Mon, 19 Dec 2016 07:49:55 GMT

Hi davies,

in pivot table values are coming correct,i am eliminate the null values of lesse

in bar chart iam not able to eliminate the null values of lesse

if we uncheck the null values of lesse then pivot and bar chat are matching