topic Re: filtering particular row without affecting calculation in QlikView

filtering particular row without affecting calculation

vikas12345 — Mon, 19 Aug 2019 07:20:58 GMT

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

Re: filtering particular row without affecting calculation

tresB — Mon, 19 Aug 2019 07:37:56 GMT

You could try something like:

FieldValue('YourField', 1)

Re: filtering particular row without affecting calculation

vikas12345 — Mon, 19 Aug 2019 07:51:08 GMT

Sorry, It's not working

Re: filtering particular row without affecting calculation

tresB — Mon, 19 Aug 2019 07:57:36 GMT

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.

Re: filtering particular row without affecting calculation

vikas12345 — Mon, 19 Aug 2019 08:52:04 GMT

Re: filtering particular row without affecting calculation

tresB — Mon, 19 Aug 2019 09:23:04 GMT

And how is your variable defined?

Re: filtering particular row without affecting calculation

vikas12345 — Mon, 19 Aug 2019 09:40:50 GMT

Variable description is,

=service_code&'--'&service_desc

Re: filtering particular row without affecting calculation

tresB — Mon, 19 Aug 2019 09:47:45 GMT

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

Re: filtering particular row without affecting calculation

vikas12345 — Tue, 27 Aug 2019 19:24:11 GMT

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