topic Use variable to set a max value for a field in QlikView

Use variable to set a max value for a field

Tue, 15 Jan 2013 00:44:46 GMT

Hi All,

I am trying to use a variable to control the value of a field and in return filter out the data set based on that. I am giving user an input box where he can enter a max value and that should filter the entire charts on the report.

I am using an input box and I have to set a trigger that can set the maximum value of the field to the value input by the user. Can anyone please help me achieving this or recommend any other possible solution?

Eg: my field name is Rank.

So if a user enters a 15 into the input box, the field rank should select all the records from 1 to 15.

Thanks for your help.

Re: Use variable to set a max value for a field

Sokkorn — Tue, 15 Jan 2013 01:30:46 GMT

Hi,

Let do this:

1. Create variable for input box called vMax

2. Create list box with expression =Aggr(Only({$<Rank = {"<=$(=vMax)"}>} Rank),Rank)

See the sample attached file

Hope this help.

Regards,

Sokkorn

Re: Use variable to set a max value for a field

Tue, 15 Jan 2013 06:30:41 GMT

Hi Sokkorn,

Thanks for your reply. What your above app is doing is selecting the values for the list box but not filtering out the data as a whole. I am looking for something like when a user enters a value into the input box, all the values which are less than the input value should get selected and all the other objects on the report should filter the data based on that. Does that makes sense?

Thanks again for your help.

Re: Use variable to set a max value for a field

Tue, 15 Jan 2013 06:54:03 GMT

Hi,

i tride with sample data in my attachment.. the input box variable you have to call in all your reports else it won't filter the data according to my knowledge..

//Chandra

Re: Use variable to set a max value for a field

Tue, 15 Jan 2013 06:59:35 GMT

Hi Chandra,

I am not sure, but it looks like your app is not working. My requirement is - I have a field which has numeric values.

I want to create an input box where a user would enter a maximum value. Example - if a user enters 6, all the values from 1 to 6 will be selected. So like when we select mutiple values in a list box, it greens out and select related data in other charts and graphs in the dashboard. In a similar way, as soon as a user would hit enter it will select all the 6 values automatically.

Thanks for your reply.

Re: Use variable to set a max value for a field

Sokkorn — Tue, 15 Jan 2013 07:07:32 GMT

Hi,

Let add variable event trigger by goto Setting ==> Document Properties ==> Triggers ==> Variable Event Triggers ==> OnChange ==> Add Action(s) ==> <Select in Field>

1. Field box put Ranks

2. Search String box put ='(' & Concat(Aggr(Only({$<Ranks = {"<=$(=vMax)"}>} Ranks),Ranks),'|') & ')'

See sample file also

Let me know after you test

Regards,

Sokkorn

Re: Use variable to set a max value for a field

jzimolong — Tue, 11 Mar 2014 16:55:03 GMT

I know this is very old, but can the Search String formula above be expanded to have a lower boundary as well, from a user input variable?

Essentially doing a < vMax AND > vMin

How can I weave that into the formula?

Re: Use variable to set a max value for a field

jzimolong — Tue, 11 Mar 2014 18:17:29 GMT

Please disregard my previous question, I was able to figure it out. Great technique.