topic Re: Greater <= & >= in QlikView

Greater <= & >=

dhanavindhan — Tue, 20 Mar 2018 10:18:09 GMT

Hi Experts,

I have a table with negative and positive values. My filter was this (Freedays>=14 & Freedays<=14).

Like this,

If I click on any one it should filter the record in the table for the corresponding condition. I don't know how to do this. Pls help me.

Thanks in advance

Regards,

Dhana R

Re: Greater <= & >=

olivierrobin — Tue, 20 Mar 2018 10:37:26 GMT

hello

you have to associate each row of your input table to one of the values of your filter, say

let filter=(if value<14,'less than 14','gt than 14')

create a list box showing filter

Re: Greater <= & >=

dhanavindhan — Tue, 20 Mar 2018 10:52:59 GMT

Thanx for the reply.

Could you pls eloborate this? I am not getting what you are coming to say.

Re: Greater <= & >=

dhanavindhan — Tue, 20 Mar 2018 10:53:47 GMT

Click on the image it will show you all the columns.

Re: Greater <= & >=

olivierrobin — Tue, 20 Mar 2018 11:00:26 GMT

you say you have positive and negative values.

I understand this is stored in a field which i called "Value"

is this correct ?

if not, you have to find a way to determine that value (diffrence between 2 fields of someting else)

Re: Greater <= & >=

dhanavindhan — Tue, 20 Mar 2018 11:17:42 GMT

Re: Greater <= & >=

Peter_Cammaert — Tue, 20 Mar 2018 14:05:18 GMT

You can use Set analysis with an expression search. The actual expression will be chosen by selecting one from a listbox and patching it into the set analysis expression using $-sign substitution.

For example (by lack of further details from your side, I'm inventing my own situation here):

In your script, either create a date island containing your two expressions as text Call the field "Filter"
Put a listbox on your sheet that displays Filter values. Select one and in properties->General, enable "Always one selected value".
Now create a Straight table, and in all expressions add the following set analysis expression. Use a field that has a unique value for every row in your facts table (an ID or a Transaction number):
... {<[SRR No] = {"=$(=Filter)"}>} ...
Test

You can also get this effect using a variable and an Input Box object instead of a date island.

Are you sure that you want an overlap between the two filters? Or do you prefer something like Freedays <= 14 and Freedays > 14?