topic Displaying Data.... in QlikView

Displaying Data....

hopkinsc — Thu, 19 Aug 2010 11:49:59 GMT

Hi, i have an application that i am writing for transactions.

In my script i have the following..

LOAD *, 1 AS CustomerSalesValueRangeSelection INLINE [

Sales Value Range

All Values

Equal To Entered Value

Between Entered Values

];

I have then created a LIST BOX which displays the above fields.

When i click on a field above i,e 'Equal To Entered Value' I have then got an input box to appear where the user can enter a transaction value.

The input box is mapped to a field called 'Amount'.

The same thing happens if the user click the 'Between Entered Values' (but 2 input boxes appear).

The problem i am getting is if i enter a value into a list box, the value appears in my current selection (which is what i expect) but when i click on 'All Values', my initial selection is still selected. I do not know how to tell it that 'All Values' should include everything.

Does anyone know how to do this please?

And also my 'Between Enterd Values' selection doesn't work. i can enter a GREATER than figure, but when i enter a LESS than figure it wipes out my GREATER than because they are using the same field. Can i use the same field for 2 different selections?

I have attached my example

Displaying Data....

hopkinsc — Fri, 20 Aug 2010 10:02:02 GMT

Any help with this?

Displaying Data....

hopkinsc — Fri, 20 Aug 2010 11:30:35 GMT

No thoughts anyone?

Displaying Data....

Fri, 20 Aug 2010 13:25:58 GMT

Hi,

Here you are a possible solution for your problem.

Check out the document properties, Triggers, Sales Value Range fiel select action for Equal case, and the Find button action for between case.

I hope it helps you.

Regards.

Displaying Data....

hopkinsc — Fri, 20 Aug 2010 16:20:32 GMT

Thanks Miguel, that worked great 🙂

Is there any way though that on the Greater than and Less than input boxes, the £ sign can go on automatically? That way the user only has to enter numbers, i.e. 1.50 but the input box displays £1.50 instead of typeing £1.50?

Your help is very appreciated..

Displaying Data....

Mon, 30 Aug 2010 07:17:52 GMT

Hi,

I was on vacations, so I'm sorry by the late answer.

I think there is a way for that but it could be very expensive for the document's performance. It's better the user expends a few seconds writing the value that all the document works slowly.

Regards.