topic Re: Cross table showing wrong data in QlikView

Cross table showing wrong data

narender123 — Tue, 27 Sep 2016 06:53:34 GMT

Hi All,

I have created a cross table like

Table1:

load

column1, column2,column3, column4,Value,VAT,SC,AD,BL

from table1;

Sum(Value)=100

Cross Table:

crosstable(Tax_Type,Total_Amount,5)

column1, column2,column3, column4,Value,VAT,SC,AD,BL

from table1;

Sum(Value)=80

When I take sum(Value) in normal table then it shows right data 100.But in cross table, sum(Value) shows wrong data 80 means less than original result.

Please tell me to sort out this??

Thanks,

Narender

Re: Cross table showing wrong data

Anil_Babu_Samineni — Tue, 27 Sep 2016 07:14:03 GMT

I am not purely sure i unerstand your requirement, but better moving forward try to share the excel and tell me which you are under stucked with image snap.

Re: Cross table showing wrong data

avinashelite — Tue, 27 Sep 2016 07:19:36 GMT

Do you have any null values in the data set ?? share the sample data so that we can understand the issue better