Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

maly0606
New Contributor II

Show Value from column2 based on the value from column1

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 ... 

 


Qlik.JPG  

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

 

3 Replies
MVP
MVP

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

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)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
maly0606
New Contributor II

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

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

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

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...