Reload Data based on a selected value

[#1]

Hi All,

I have a table that has customer names. I want to be able to select the customers name and then use this value to reload addittion data based on the value that I select. How do I do this? Ive tried drinking a glass of water with my head tipped upside down and also running round the garden naked at night none of which have been affective?

Wayne

[#2]

have you tried rebooting you system?:P

[Gysbert_Wassenaar · Accepted solution]

You can do it with a variable (v_Customers) to store the selections and a partial reload using the variable in a where clause. See attached example.

Customers:

load * from customers.qvd (qvd);

Customerdetails:

REPLACE ONLY load * from customerdetails.qvd (qvd)

where match(customername, $(v_Customers));

[#4]

Gysbert, You are the man!

Thank you very much indeed, thats exactly what I was looking for

Wayne

[techvarun]

I need to pick the values between two dates and extract the values from a stored procedure

[PriyankaShivhare]

I have the same requirement in Qliksense but i want to autoreload the data based on current selection in field...how can we achieve this

[JHuis]

Did you find a resultion for this?