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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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 ..