topic Re: Re: only show the expression outcome values that fall between two given numbers by a user in QlikView

only show the expression outcome values that fall between two given numbers by a user

pheaxx_2014 — Wed, 26 Nov 2014 09:06:22 GMT

Hi,

i treid to search the forums but could not find my answer.

my situation is that i need to be able to select only a part from an outcome of an expression.

the expression outcome is in % and i need to be able to select only the expression values that are between 50%-70%.

These 50%-70% bracket must also be able to be changed on the fly.

so is there any way to only show the expression outcome values that fall between two given numbers by a user?

thanks in advance.

gr Nick

Re: only show the expression outcome values that fall between two given numbers by a user

Anonymous — Wed, 26 Nov 2014 09:45:33 GMT

Hi Nick

please attach the sample QV app

Regrads

harsha

Re: Re: only show the expression outcome values that fall between two given numbers by a user

pheaxx_2014 — Wed, 26 Nov 2014 10:10:35 GMT

Hi Harsha,

i made a sample file, the line in the chart is the conversion, and over that expression i need to be able to select a part that is given by the user.

Gr, Nick

Re: Re: Re: only show the expression outcome values that fall between two given numbers by a user

PradeepReddy — Wed, 26 Nov 2014 10:18:12 GMT

Create a calculated dimension depends on the min and max values.

Please find the attached application, it might be helpful.

Re: Re: only show the expression outcome values that fall between two given numbers by a user

pheaxx_2014 — Wed, 26 Nov 2014 10:25:30 GMT

It's almost what i need, but i'm getting problemens since i have two of the same expressions but each with different state for to compair them with each other, but i have only one dimension.

so how would the calculation look then?

Re: Re: Re: only show the expression outcome values that fall between two given numbers by a user

PradeepReddy — Wed, 26 Nov 2014 10:47:52 GMT

I have done some modifications in your expression.

Please find the attached application.

Re: Re: only show the expression outcome values that fall between two given numbers by a user

pheaxx_2014 — Wed, 26 Nov 2014 12:01:12 GMT

using a calculated dimension works perfect for me, thanks.

I only have one stange thing now, i'm getting an , in my chart(see attached picture)

i can not seem to find why i'm getting this in my char and how to fix is.

Re: Re: only show the expression outcome values that fall between two given numbers by a user

PradeepReddy — Wed, 26 Nov 2014 13:49:14 GMT

Suppress NULL values in dimension tab.