topic Return dimension based on other dimension in QlikView

Return dimension based on other dimension

Wed, 25 Nov 2020 16:16:04 GMT

Similar to SQL :

select F2 where F1='test2'

the result in to the text box should be Canada

Thanks

hector_munoz — Mon, 05 Jun 2017 21:38:03 GMT

Hi,

Try this inside text box: =If(F1='test2', F2)

Regards,
H

Mon, 05 Jun 2017 23:14:30 GMT

Thanks. I did it with Aggr function as actual data has more grouping.