topic Re: Reload Data based on a selected value in QlikView

Reload Data based on a selected value

Thu, 29 Nov 2012 14:17:13 GMT

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

Re: Reload Data based on a selected value

Sat, 01 Dec 2012 15:05:21 GMT

have you tried rebooting you system?:P

Re: Reload Data based on a selected value

Gysbert_Wassenaar — Sun, 02 Dec 2012 08:14:19 GMT

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));

Re: Reload Data based on a selected value

Sun, 02 Dec 2012 10:24:05 GMT

Gysbert, You are the man!

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

Wayne

Re: Reload Data based on a selected value

techvarun — Mon, 12 Aug 2013 09:32:08 GMT

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

Re: Reload Data based on a selected value

PriyankaShivhare — Fri, 04 Jan 2019 11:11:10 GMT

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

Re: Reload Data based on a selected value

JHuis — Wed, 15 Feb 2023 12:59:03 GMT

Did you find a resultion for this?