topic How to filter a value by a variable in QlikView

How to filter a value by a variable

paul_ripley — Wed, 10 Oct 2018 13:22:35 GMT

Hello

I have a set of data based on an excel s/sheet.

The Valuation Basis below has changed from period 201803 to 201806 from 'Price of recent investment' to 'DCF'

I just added Valuation basis as a dimension and it returns 'Price of recent investments' no matter what period I choose.

So I am thinking that maybe I have to use a calculated dimension.

For the current period I use a variable 'vEndPeriod'.

So I was thinking so that it returns the correct Valuation basis for the period I would pick a calculated dimension or an expression (not sure which) and but not sure what I would use.

Could anyone help please!

Thanks

Paul

Re: How to filter a value by a variable

jayanttibhe — Wed, 10 Oct 2018 13:27:49 GMT

Can you please share sample app? Also, how you are defining the Start Period and end Period. It looks like you have one Row in your app for these 2 records OR atleast you want to consider it that way?

Re: How to filter a value by a variable

paul_ripley — Wed, 10 Oct 2018 13:41:26 GMT

So I have an input box where I have renamed vEndPeriod as Period to

So in this case because vEndPeriod is 201806 I just want to pick the second line and column L DCF

Does that help?