Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

repeatable fields once

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.

4 Replies
Not applicable
Author

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?

Not applicable
Author

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 ...

Not applicable
Author

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

Not applicable
Author

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 ..