topic Re: only two records in QlikView

only two records

Anonymous — Fri, 30 Jan 2015 10:44:52 GMT

Hi All,

I have one attached qvw.

So I want only two record that is 345 -

456 -

thanks

Re: only two records

rubenmarin — Fri, 30 Jan 2015 10:48:43 GMT

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.

Re: only two records

Anonymous — Fri, 30 Jan 2015 11:26:55 GMT

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

Re: only two records

rubenmarin — Fri, 30 Jan 2015 11:34:29 GMT

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: