Discussion Board for collaboration related to QlikView App Development.
I have a data set as follows:
Rcv Status Rcv Date Load Status Load Dt Loaded Status Loaded Dt
12 10-06-2010 22 11-06-2010 23 12-06-2010
What I want to achieve is I should have a listbox with the values 12,22 and 23. Based on my selections I have another list box called Date
which has values as Jan-2010, Feb -2010 etc.
So when I select status 12, this date listbox should actually pass the values for Rcv Date, similarly when 22 selected it should pass the values of Load Dt and Loaded Dt when 23 is selected.
How Can I go about achieving this.
load RcvStatus as Status,
RcvDate as Date
load LoadStatus as Status,
LoadDate as Date
from xyz ;
load LoadedStatus as Status,
LoadedDate as Date
Now you have 2 fields with the corresponding values.
View solution in original post
thanks for the reply sir.
Once I get these 2 fields, when I select 12 (Rcv status) wont the date listbox show me values for all the status.
E.G. loaded data is as follows
So when I select drop down value 12 - it should select dates as 12-05-2010 and 12-07-2010
when I select drop down 22 - it should select dates as 12-06-2010
and when I select 23 - it should select date 12-07-2010
The selection should be independent of the status but from the same date field. Will this work as per your solution.