only two records

[Anonymous]

Hi All,

I have one attached qvw.

So I want only two record that is 345 -

                                                    456 -

thanks

[rubenmarin · Accepted solution]

Hi vijay, in a List Box you can get those values with:

=Aggr(If(Count([INVOICE NO])=1, [INVOICE NO]), [INVOICE NO])

You also can use this expression in a calculated dimension.

[Anonymous]

Hi Ruben,

This is only for two records if I have thousands of record then....

pls check below

INVOICE NO	PO_NO
123	A
123	D
123	A
123	A
123
123
234	B
234	B
234
234
345
456
678	D
678
678
998
984
659
224
123
333
555
555
125
147
985
123	B
234
678	C
111
111
111	B
111

Thanks

[rubenmarin]

Hi vijay, from the data and result expected I supposed you want the records wich aren't repeated, if this is what you want the same expression can work, if there is a different requirement..what' the requirement?

For the last data, using the same expression I get: