topic Re: Cross table wrong data in QlikView

Cross table wrong data

narender123 — Wed, 19 Oct 2016 09:48:54 GMT

Hi All,

I have created a cross table and after that it is showing wrong amount as shown in attached 1_screenshot. In 1st screen shot the sum(TAX) is 342446699 but in real total amount should be 38049633.because 38049633 is the total amount of all tax code but cross table creating this total amount for each tax code individually and that's why it is showing wrong data. Please tell me why cross table showing wrong data??

Thanks,

Narender

Re: Cross table wrong data

sergio0592 — Wed, 19 Oct 2016 09:55:15 GMT

Try this :

=aggr(sum({<FLAG={'B'}>}STATISTICAL_VALUE),TAX_CODE )

Re: Cross table wrong data

sunny_talwar — Wed, 19 Oct 2016 09:57:40 GMT

How does your script look where you have implemented the cross table?

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 09:59:08 GMT

Thanks Jean.

I know it will show right amount but my question is that why is showing wrong data ??

and how we can sort out this in script level not in chart level.??

Re: Cross table wrong data

vinieme12 — Wed, 19 Oct 2016 10:00:23 GMT

Are You doing a Left join after your crosstable load??

This is the only thing that will cause your data rows to repeat for each fieldvalue

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 10:24:39 GMT

No I am not doing any Left join but I am doing concatenation after cross table.

Re: Cross table wrong data

vinieme12 — Wed, 19 Oct 2016 10:32:54 GMT

can you post the script?

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 10:38:06 GMT

Please see below cross table.

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 10:39:00 GMT

Please see my reply for Sunny.

Re: Cross table wrong data

sunny_talwar — Wed, 19 Oct 2016 10:41:11 GMT

Are you using a variable as your expression? May be you have to remove the equal sign from the variable.

Re: Cross table wrong data

vinieme12 — Wed, 19 Oct 2016 10:47:50 GMT

as Text!

Re: Cross table wrong data

vinieme12 — Wed, 19 Oct 2016 10:55:57 GMT

Lets Break your Cross Table into two steps and try

First load your fields and create a new key field

TABLE1:

LOAD

RecNo() as newKey

From YourSource;

Left Join (TABLE1)

CROSSTAB(TAX_CODE,TAX,1)

newKey

Taxfield1

Taxfield9

Resident TABLE1;

DROP FIELDS Taxfield1 , ,,,,,Taxfield9 from TABLE1; //DROP ALL TAXfields that we will be crosstabbing

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 10:56:32 GMT

I have shown you in my question with 1_screenshot screen shot . You can see in that screenshot expression, I didn't use any variable.

So where you saw the variable??

Thanks

Re: Cross table wrong data

sunny_talwar — Wed, 19 Oct 2016 11:00:18 GMT

I don't see any variable, but what I am asking is that are you using this expression directly in your chart or are you saving the below expression in a variable and then using the variable in your chart?

I have seen this kind of behavior when the expression is saved in a variable and then the variable in used in the chart instead of using the expression directly. That was the reason I asked this.

Re: Cross table wrong data

narender123 — Wed, 19 Oct 2016 11:19:30 GMT

No i am using this expression directly in chart.

Re: Cross table wrong data

sunny_talwar — Wed, 19 Oct 2016 11:38:46 GMT

I guess it would be helpful if you can share a sample where you can replicate this issue

Re: Cross table wrong data

vinieme12 — Wed, 19 Oct 2016 13:07:04 GMT

have u tried the above ?