topic Filter Chart Data based on Input Box in QlikView

Filter Chart Data based on Input Box

Fri, 11 Nov 2011 11:57:58 GMT

Hi All

I want to filter chart data based on user input in an Input Box. I want to filter data to show single invoice no entered by user in an input box.

I searched previous threads but none of them describe complete solution.

Can someone help pl?

Regards

Anu

Re: Filter Chart Data based on Input Box

Fri, 11 Nov 2011 12:23:07 GMT

Hi,

See attached example for your solution.

First make a variable.

Succes, Halmar

Filter Chart Data based on Input Box

Sat, 12 Nov 2011 10:30:36 GMT

I cant open attached QVW. Can you pl send the instructions here

Filter Chart Data based on Input Box

Sat, 12 Nov 2011 10:59:56 GMT

I could open QVW and it works. but i also need additional condition where if there is no value entered in input box then it should show all data. any idea how i can add this additional condition?

Filter Chart Data based on Input Box

Mon, 14 Nov 2011 13:37:04 GMT

Try this in the expression. The user should set it to 0 to see all the invoices.

if(Input=0,sum(Value),

sum({<InvoiceNo={"$(Input)"}>} Value))

Halmar

Filter Chart Data based on Input Box

Fri, 09 Mar 2012 16:20:27 GMT

Hi,

I've an expression like: sum(distinct Sales)/1000 in a st. table having 8

dimensions...now the expr can range from 0 to any big value.i want to create an

input box where the user can enter a number & the expression shud show only the

values wich are greater than the value entered by the user.

Plz help