filtering particular row without affecting calculation

[vikas12345]

Hi Guys,

I want to make filter (List Box) for a particular field value without affecting the calculation. I want same calculation in qlikview Like LookUp(Attr(Field),0) in Tableau

[tresesco]

You could try something like:

FieldValue('YourField', 1)

[vikas12345]

Sorry, It's not working

[tresesco]

If it is not working, there is a high possibility that you are making something wrong in writing the expression, like:

• Missing single quotes around the field name
• First element is indexed as 1. So don't use zero

If that's not the case, try to share a screen shot showing how exactly you are trying.

[vikas12345]

[tresesco]

And how is your variable defined?

[vikas12345]

Variable description is,

=service_code&'--'&service_desc

[tresesco]

Are you sure that - after evaluating this expression whatever it comes - is a fieldname ? Could you share a sample app?

[vikas12345]

yes, after evaluating the expression fieldname is coming. But result as i want, is not coming.