topic Re: Box / Object in QlikView

Box / Object

Tue, 28 Apr 2015 14:38:42 GMT

Hi All

I have a straight chart table showing Months Stock Holding ( which is Stock on Hand / Average Monthly Sales). (see below) I want to create a box / object where I want to see , for eg, Items where stock holding is less than 4 months , or Stock Holding greater than ,say 10 months. So if i select one of these criteria, it should only show these values in my straight table.

How do i create this object / box.

kind regards

Nayan

Re: Box / Object

Anonymous — Tue, 28 Apr 2015 14:44:06 GMT

if stockholding column is already calculated in script.

you can add one more column

if (stockholding <4,4,10) as stockholdingFilter

and then use this field as your filter .

Thanks

BKC

Re: Box / Object

Tue, 28 Apr 2015 14:47:48 GMT

Hi BKC

Thank you for your reply. The stock holding calculation is in the front end and not in the back ground script. Also i can create an extra column , but i prefer a box/ object ..similar to a list box.

kind regards

Nayan

Re: Box / Object

morganaaron — Tue, 28 Apr 2015 14:55:08 GMT

You can search within a listbox using an expression that would calculate this.

If you type into the search bar of a listbox for ItemCode "=[Average]/[SOH]<4" replacing those place holders with your actual expressions, that should give you all ItemCodes that your calculation returns a value of less than 4 for.

Re: Box / Object

Wed, 29 Apr 2015 06:36:19 GMT

Hi Aaron

Thank you for your reply. Apologies for replying late as I left for home last night. I created a variable and here is my expression, however it does not work. Can you tell me where i am going wrong.

if($(SOH)/$(Average_Sales) < 4, 'Low Stock Holding',
if($(SOH)/$(Average_Sales) > 10, 'Overstocked', 'OK'))

kind rgards

Nayan

Re: Box / Object

morganaaron — Thu, 30 Apr 2015 12:56:47 GMT

You look like you're trying to assign values to something, which won't be working.

What I stated is for filtering the list box, so think of things such as numerical conditions or true/false statements.

If you want all your "low stock holding", you could just use the first part of your expression:

=$(SOH)/$(Average_Sales) < 4

And that should calculate and return those that are less than 4 for example.