Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikas12345
Contributor II
Contributor II

filtering particular row without affecting calculation

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

8 Replies
tresesco
MVP
MVP

You could try something like:

FieldValue('YourField', 1)

vikas12345
Contributor II
Contributor II
Author

Sorry, It's not working

tresesco
MVP
MVP

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
Contributor II
Contributor II
Author

clipboard_image_0.png

tresesco
MVP
MVP

And how is your variable defined?

vikas12345
Contributor II
Contributor II
Author

Variable description is,

=service_code&'--'&service_desc

tresesco
MVP
MVP

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

vikas12345
Contributor II
Contributor II
Author

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