topic repeatable fields once in QlikView

repeatable fields once

Fri, 22 Jan 2010 11:13:28 GMT

hello,

I view my accounts data as a T-account:

customer account (debit) a item (credit)
VAT (credit)

Therefore, I can see the "customer account" only once instead of seeing him always repeated?

thanks for the help and sorry for my english... es.

repeatable fields once

Fri, 22 Jan 2010 11:17:22 GMT

Can you expand a bit more, what does the data look like? Are all fields in the same column? If so why not use a pivot table?

repeatable fields once

Fri, 22 Jan 2010 11:35:32 GMT

ok...this is the example

the field "conto" (sign D) 1102999989 is repeated more than once in the face of n counterparts (sign A) ...

I would repeat it only 1 time ....

Ah, the field "conto" is a file to the field "S" (= D),
from the field "contabilitagenerale.importo" is another file ...
the 2 files are attacked by the "data / N ° reg."

with a pivot fields from the "contabilitagenerale.importo" on you do not appear to me ..

I do not know is there any keyword that allows me to see the field "account" only once??

I hope that I explained a little better ...

repeatable fields once

Fri, 22 Jan 2010 11:50:46 GMT

I think I understand what you mean, why don't you use the distinct command in your table?

So make a straight table and use the expression:

Sum (Distinct conto),

You can even do a distinct load if you don't want to detail at all.

Does that help?

Ben

repeatable fields once

Fri, 22 Jan 2010 12:25:08 GMT

sorry but I did not understand ...

the chart that I sent you before is a table on the table ... I can sum (DISTINCT)?

the script can not do it, because the file where there is the "account" has other fields that I need ..

I am attaching txt where I'll show you the result and outcome of the pivot table ..