Filter Chart Data based on Input Box

[#1]

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

[#2 · Accepted solution]

Hi,

See attached example for your solution.

First make a variable.

Succes, Halmar

[#3]

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

[#4]

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?

[#5]

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

[#6]

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