Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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.