topic Re: How to Get value to another Field in QlikView

How to Get value to another Field

bsbernabe — Sat, 16 Nov 2024 00:48:54 GMT

Hello There,

The concern is about how to get the Age of the Data Type base on Account No.

I try to do that :

Only({<[Data Type] = {Repo}>} [Age]) but not working.

sample data source:

Account No.	Data Type	Age
123	ABC	30
456	EFG	40
789	ABC	5
910	HIJ	10
111	ABC	2

Should be output:

Age

Can you share with me how to do that?

Best Regards,

Bing

Re: How to Get value to another Field

Vegar — Mon, 20 Apr 2020 07:09:17 GMT

Why are you using Repo in Only({<[Data Type]={Repo}>}[Age]) ?

Try changing to 'ABC'. Only({<[Data Type]={'ABC'}>}[Age])

When using Only then you need to make sure that you only get one value per dimension combination in your table. So in your example outpu you would ned to have Account No. as a dimension as well.