topic Re: Show Value from column2 based on the value from column1 in QlikView

Show Value from column2 based on the value from column1

maly0606 — Mon, 04 Mar 2019 11:08:25 GMT

Hello

I wanna show in text object value from column Activtity based on the value from column TA_number

1.) IF(TA_number=2,Activity) result should be " PIPO " , but it does not work..

2.) In "show conditional" object i want have formula which should works like - show object if you found value 6 in column TA_number

I tried with formula FieldValue,Match ect and it does not work ...

How it work function FieldValue ? I wrote function FieldValue(Activity,2) and i thought that function return second value from column Activity but i have blank object ..

Thank you very much in advance for your help

Best Regards

Marcin

Re: Show Value from column2 based on the value from column1

jonathandienst — Mon, 04 Mar 2019 11:27:31 GMT

Your expression 1 should work if '2' is selected in TA_number. If nothing is selected, TA_Number will return null as Qlik cannot determine which value of TA_number you mean. I am not sure what you are wanting to do, but will this help:

Only({<TA_number = {2}>} Activity)

Re: Show Value from column2 based on the value from column1

maly0606 — Mon, 04 Mar 2019 11:33:37 GMT

Yes it works 🙂 thank you
for conditional show object I should use the same function only ?

Re: Show Value from column2 based on the value from column1

maly0606 — Mon, 04 Mar 2019 12:35:03 GMT

Ok my second issue IS solved by using function count, I am counting rows in table and object is show when in table are more than X rows...