Qlik Community

QlikView Documents

Documents for QlikView related information.

INPUT BOX can be your best friend - as a Developer and Analyst ...

MVP
MVP

INPUT BOX can be your best friend - as a Developer and Analyst ...

At least it is my best friend - and I am sure that it can become yours too if you get to know Input Box better.

I use it almost all the time now to debug my expressions. It is much quicker to enter expressions in an input box than going in and out of Charts to do the same. So I use input box as a scratchpad and development workbench to more quickly get to the expression that will get me the right calculation.

It took me a few months to discover what I thought I should have known from the start when I started learning QlikView. I kept clicking in and out of chart properties adjusting my expressions and fiddling with them and started hating all this clicking back and forth. I was told to use Text Box to put my expressions there to test them and I did that too.

Then one day I realized that Input Box can accept expressions too... on the fly. And of course that is much much quicker than going into Chart Properties and editing expressions. And it is also quicker and more immediate than editing Text Boxes too.

I soon learned to just create a List Box with some standard variables which I kept short to make it quick and easy. I usually have this kind of List Box with variables A1, A2 .... A9 or v1 ... v9 in all QlikView applications I develop. Then I can use that to test some ad-hoc expressions and interrogate the data model too from this scratch-pad with just generic variable names.

I can also explore any function more thoroughly but best of all I can break a complex expression into several more manageable steps by putting it into several variables referencing each other. It reminds me quite a bit about how I would work in Excel with complex formulas and it works very well. It mimics a column of Excel cells with formulas in fact. So now Input Box is totally indispensable for me. Speeding up my development and saving me a lot of frustration.

I will make a more comprehensive blog about specific use cases demonstrating the benefits with screenshots quite soon. Maybe already this week-end.

Hope this inspires someone else to adopt what I think should be a part of the practice of most QlikView Designer/Developers/Analysts workbench and practice.

I am curious if anyone else is using Input Box in the same way - I haven't come across anyone yet in fact.

Comments
carbal1952
Contributor II

I still standing your post to know what are you talking about.

Please, don't forget some examples too.

CB.

MVP
MVP

If I understand you right ... you say you have a problem understanding what I am talking about...?

OK - I had a second look at the article and I might be a bit vague here so I added more specific information at the beginning to clarify what it is all about. Thanks for the feedback  

sergey_maka8
Valued Contributor

Sounds very interesting, but it would be good to see some examples.

For example, recently I've found a useful feature of Input Box to move variables across several applications.

You can create an InputBox in one app to show the variables.

Then just copy it into another and you can assign values to the same variables (copy/paste or manually) even if they haven't existed in the second app before.

Regards,

Sergey

Not applicable

You are saying about assigning all major expressions into variables right?

Not applicable

Hey the concept sounds great, but would be easy to understand with example, specifically screen shots.

What I got from the above explaination is that the input box literally works like a cell of excel.

wherein we can put formulas & evaluate the stuff, rather than taking a text box & going to it properties & setting the expression in it! right ?

Regards

Swapneel

MVP
MVP

Thats correct - and I will allocate some time now to get around to write up some examples to illustrate some uses of this.

Not applicable

Oh great

Thanks for all that

I will surely try it till then thanks for sharing the best friend

Regards

Swapneel

Not applicable

Very helpful and cool. And yes a good practice to follow.

Regards,

KC

carbal1952
Contributor II

Mr.Petter Skjolden:

I never used INPUT boxes and the examples you gave are not enough to understand your point.

Why don't you write some code about it and post it.

Thanks.

CB.

sun_dip08
New Contributor III

Hi, Can we filter the report by inputting like 10 to 50 different values from any flat file (like excel or text). I use predefined variable in input box and can input values one by one. Just want to know if we have Any ways to input values from flat file and filter the report.

Version history
Revision #:
1 of 1
Last update:
‎05-08-2015 10:22 AM
Updated by: