topic Re: Input box based on expression column in QlikView

Input box based on expression column

montubhardwaj — Tue, 29 Nov 2011 20:11:09 GMT

Hi all,

I have a Pivot Table and I want to have the ability to choose Area or Country with minimum change in sales i.e Diff. For example, user can enter values (Diff values)in the Input Box and only corresponding countries should reflect in the chart. How to trigger the vaible in the Input box to relate to the values in Diff Coulnn? How this can be achieved. If a user is entering ">200" in Input box, only Hungry should be shown. Please refer to the below sample example.

Let me know if any staright method/workaround is available for this. Thank You in advance.

Regards,

Sharma

Input box based on expression column

Tue, 29 Nov 2011 20:28:38 GMT

What about a slider ?

You can create a variable then a slider with this variable Var

Then change the expression : If ( sum( Sep_Sales)- sum( Oct_Sales) > $(Var) ; sum( Sep_Sales)- sum( Oct_Sales) )

Input box based on expression column

Tue, 29 Nov 2011 20:32:27 GMT

Hi Sharma Sharma

2 ways of doing this - depends on how you have set up the and the data behind it. If the diff column is a straighforward field, you could use a variable exapnsion in set analysis to search on diffs that are equal to the variable, eg {< Diff = {$(vinput_variable)}>} .

Other method would be to set a trigger to run an action for when the variable changes. You can do this by going into the Settings - > document properties dialogue and selecting the triggers tab. Select the variable you want, then add an action to select in the country field based on the variable.

The search string is like a normal search string that you can enter in a list box. So you can search for countries where the search string is something like "= sum(SeptSales) - sum(OctSales) " & vinput_variable.

Let me know what you try and what works.

Regards, Erica

Re: Input box based on expression column

montubhardwaj — Wed, 30 Nov 2011 05:30:50 GMT

Hello Erica,

Thanks for your solutions. This was indeed was very helpful. I got your point of having trigger based on input value. I am trying to do the same way but the condition in "Search String" is not working. I am not sure If I am making mistake.

I have attached a sample file. Please have a look and let me know.

Many thanks for your time.

Regards,

Sharma

Re: Input box based on expression column

SunilChauhan — Wed, 30 Nov 2011 05:55:01 GMT

see the attached sample file for input hope this may help

Re: Input box based on expression column

montubhardwaj — Wed, 30 Nov 2011 06:46:55 GMT

Hi Sunil,

I want to have input box for expression column(which is not a direct field). I dont want to have it for dimension.

Thx fr your time.